Microsoft Dynamics 365 | Integration, Dataverse...

Check if there are records created by certain user

(0) Share

Report

Posted on by kirillsokolov

Hi all

I need to check if there records of entity created by certain user (createdby equals userId). I suppose query with aggregate count (webapi or fetchXML, doesn't matter) is OK. If count > 0 then there are records, pretty obvious.

I wonder if there is some more efficient way to do this. Like Any in LINQ, so that it doesn't go through all collection after finds first element which satisfies the condition.

I found Any function in WebAPI. But as I understand it is only applicable for collection-valued properties of entity

All responses (2)

Answers (0)

Suggested answer

Bipin D365 28,981 Moderator on at

Like (0)

Report

RE: Check if there are records created by certain user

Hi,

Use Count aggregate option in fetchxml to retrieve record count based your filter criteria. Then check if count>0.

docs.microsoft.com/.../use-fetchxml-aggregation

Please mark my answer verified if i were helpful
Suggested answer

sdfasdf 840 on at

Like (1)

Report

RE: Check if there are records created by certain user

If you just need to determine whether a particular user created records or not, you may want to limit this query to retrieve the top 1 result. If any results are retrieved, then you can be certain that the user created at least one record. With FetchXML, you can you the top="1" attribute.