web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Pass multiple condition values in fetch xml

(0) ShareShare
ReportReport
Posted on by

Hello Guys,

I got a reqirement were i need to fetch records from hd_devinfreg entity  where it returns me n number of hd_devinfreg i need to pass this hd_devinfreg  to my second xml to fetch details for those records i need to do a in condition where i read from a xml and input the result to another xml dynamically using a list  please help 

<fetch mapping='logical' version='1.0'>
<entity name='hd_devinfreg'>
<attribute name='new_devmemcod' />
<filter>
<condition attribute='hd_devmercod' operator='eq' value='Jumei02000' />
</filter>
</entity>
</fetch>

<fetch version='1.0' distinct='true' >
<entity name='hd_cusledmst' >
<attribute name='hd_lead' alias='MerchantCode' />
<attribute name='hd_ledsubcod' alias='MemberCode' />
<attribute name='hd_ledcus' alias='SegmentCode' />
<filter>
<condition attribute='hd_lead' operator='eq' value='Jumei02000' />
<condition attribute='hd_ledsubcod' operator='in' >
<value>2000133405</value>
<value>2000238165</value>
</condition>
</filter>
</entity>
</fetch>

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Clem Profile Picture
    2,541 on at
    RE: Pass multiple condition values in fetch xml

    Hello,

    The IN operator is not supported by  fetchxml if i'm correct.

    If you have only few values you can use the "OR" operator.

    Clément

  • Suggested answer
    sandeepstw Profile Picture
    4,601 on at
    RE: Pass multiple condition values in fetch xml

    hi,

    Check out this link:

    community.dynamics.com/.../196006

    Please mark this as verified.

    Thanks

    Sandeep

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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
HR-09070029-0 Profile Picture

HR-09070029-0 2

#1
UllrSki Profile Picture

UllrSki 2

#3
ED-30091530-0 Profile Picture

ED-30091530-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans