FetchXML linked entity filter based on parent entity

(0) Share

Report

Posted on by Community Member

How can i create a fetchxml query where the linked entity is filtered based on the parent entity. see the bold, red condition below. How can I achieve that??

<fetch version='1.0' output-format='xml-platform' mapping='logical' distinct='true' >
<entity name='entity1' >
<attribute name='entity1_primaryid' />
<link-entity name='entity2' from='entity2_relationshipfield' to='entity1_primaryid' 
link-type='outer' >
<filter type='and' >
<condition entityname='entity2' attribute='createddate' operator='eq' 
value="enity1_datecreated"+5days />
</filter>
</link-entity>
</entity>
</fetch>

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Hemant Kumar Sahu 1,829 on at

Like (0)

Report
Copy link

Link copied!

Hi Mudassar Hassa,

You can't compare two fields in FetchXML you can compare with values.

But you can assign 'enity1_datecreated' to a variable and then add 5day.

it should be

var dateCreated= //enity1_datecreated get the value + 5days

Hope this helps you !

Hemant

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Hi,

The easiest way is to create your exact query with "Advance find" and then download the fetchXML.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

I know the way to generate the fetchXML, but the question is can I used the parent attribute in the linked-entity value filter?

Was this reply helpful? Yes No
Suggested answer

Hemant Kumar Sahu 1,829 on at

Like (0)

Report
Copy link

Link copied!

Mudassar Hassan,

You can not compare two fields in fetch xml.

Hemant

Was this reply helpful? Yes No
Suggested answer

ashlega 34,477 on at

Like (0)

Report
Copy link

Link copied!

Hi Mudassar,

+1 for Hemant, but you might try doing this:

- Create a calculated field on the child entity (DATEDIFF between parent.createdOn and entity.createdOn)

- In your fetchXml, add a condition for that new calculated field (equals 5)

Was this reply helpful? Yes No