News and Announcements icon

Dynamics 365 CommunityForums Dynamics 365 general forum Check if there are rec...

Dynamics 365 general forum

Suggested answer

Check if there are records created by certain user

(0) Share

Report

Report

Posted on by kirillsokolov

5

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

Categories:

Other Functionality

Applications and Add-ons

Customization / Solutions / SDK and API

All responses Img

All responses (2)

Answers Img

Answers (0)

Suggested answer

Bipin D365 28,962 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.

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,558 Super User 2024 Season 2

#2

Martin Dráb 228,647 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans