Share
ReportHi,
How to find the list of Entities\Parent records where child records not available or created using advance Find
*This post is locked for comments
You’re offline. This is a read only version of the page.
651
Hi,
How to find the list of Entities\Parent records where child records not available or created using advance Find
*This post is locked for comments
You can use fetchxml and linked queries to find the result. But OOB will not work. Required some other plugin like XRM toolbox .
Other option is use Rollup field to record child record count on parent and use advance find to query the parent records don't have child.
Hi There,
not very straight forward! few options :
community.dynamics.com/.../find-records-without-a-child-record-in-dynamics-365-v8-and-v9
www.itaintboring.com/.../dynamics-365-finding-all-parent-records-that-have-no-child-records
Hi,
you only can use advanced find when y ou are using crm v9.0 or above.
community.dynamics.com/.../find-records-without-a-child-record-in-dynamics-365-v8-and-v9
For retrieve data purpose
If you are using on prem, you can do it via sql query.
or
XrmToolbox (refer article)
For processing
So, if you would like to achieve via JS, you can consider to use webapi.
Else you can consider plugin and custom workflow.
Hi,
Can you add some more details to your question ? what you are trying to do ? you can try to use left outer join to find entity which don't have any child records. You can refer this post: stoneridgesoftware.com/going-beyond-advanced-find-views-and-the-xrmtoolbox-using-fetchxml-and-left-outer-joins
Hi Krish ,It is not possible in advance find but using fetch you can get results and use this fetch in plugin .Following blog might help you
www.itaintboring.com/.../dynamics-365-finding-all-parent-records-that-have-no-child-records
#1
Mohamed Amine Mahmoudi
83
Super User 2025 Season 1
#2
Community Member
52
#3
dkrishna
6
All responses (
Answers (
