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

Announcements

News and Announcements icon
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

    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

    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

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics CRM (Archived)

#1
ScottDurow Profile Picture

ScottDurow 2

#2
GJones Profile Picture

GJones 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans