Notifications
Announcements
No record found.
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
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
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
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 There,
not very straight forward! few options :
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
SA-08121319-0 4
Calum MacFarlane 4
Alex Fun Wei Jie 2
