Answered

Filtering Modified On for parent and all child records in Dataverse

(0) Share

Report

Posted on by SimonSays

168

I'm trying to find the best approach to query a Dataverse table to get a list of all records where any changes have been made to either the parent record or its children (through a 1-N relationship) in the past 24 hours. I can't seem to get this to work through FetchXml. I did consider creating another date field on the parent entity with a flow triggered by any modifications to the child table, but that feels an inelegant solution. Has anybody else got an alternative approach?

<fetch>
 <entity name="parent_entity">
 <attribute name="parent_name" />
 <filter type="or">
 <condition attribute="modifiedon" operator="last-x-hours" value="24" />
 </filter>
 <link-entity name="child_entity" from="parent_id" to="parent" link-type="outer" alias="child">
 <attribute name="child_name" />
 <filter type="or">
 <condition attribute="modifiedon" operator="last-x-hours" value="24" />
 </filter>
 </link-entity>
 </entity>
</fetch>

Thanks!

Categories:

Microsoft Dataverse with Power Apps

All responses (2)

Answers (1)

Sort by

Verified answer

a33ik 3,306 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hello,

You can use the "or" condition between fields that are on the different levels of joins. Here is an example that you can adapt to your needs:

<fetch> <entity name="account"> <attribute name="accountid" /> <attribute name="name" /> <filter type="or"> <condition attribute="modifiedon" operator="last-x-hours" value="24" /> <condition entityname="child" attribute="modifiedon" operator="last-x-hours" value="24" /> </filter> <link-entity name="contact" from="parentcustomerid" to="accountid" link-type="outer" alias="child" /> </entity> </fetch>
SimonSays 168 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you! It was as simple as that. Appreciate your answer.