Microsoft Dynamics CRM (Archived)

how to write FetchXML query for ((Cond1 OR Cond2) AND (Cond3 OR cond4))

(0) Share

Report

Posted on by MSCRM learner

170

Hi,

I need to write a FetchXML for implementing the below conditions from same entity

((Cond1 OR Cond2) AND (Cond3 OR cond4))

Please let me know if you have gone through such type of requirement and written a fetchXML.

Thanks.

*This post is locked for comments

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

Gopalan Bhuvanesh 11,401 on at

Like (0)

Report
Hi

You can use similar to the following.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"> <entity name="account"> <attribute name="name" /> <attribute name="primarycontactid" /> <attribute name="telephone1" /> <attribute name="customertypecode" /> <attribute name="accountid" /> <order attribute="name" descending="false" /> <filter type="and"> <filter type="or"> <condition attribute="name" operator="like" value="Test1%" /> <condition attribute="name" operator="like" value="Test2%" /> </filter> <filter type="or"> <condition attribute="address1_city" operator="eq" value="London" /> <condition attribute="address1_city" operator="eq" value="Leeds" /> </filter> </filter> </entity> </fetch>

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (1)

Report

Hi,

You can use following fetch XML to achieve this.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">

<entity name="account">

<attribute name="name" />

<attribute name="primarycontactid" />

<attribute name="telephone1" />

<attribute name="accountid" />

<order attribute="name" descending="false" />

<filter type="and">

<filter type="and">

<filter type="or">

<condition attribute="name" operator="like" value="%abc%" />

<condition attribute="name" operator="like" value="%xyz%" />

</filter>

<filter type="or">

<condition attribute="accountnumber" operator="like" value="%123%" />

<condition attribute="accountnumber" operator="like" value="%456%" />

</filter>

</filter>

</filter>

</entity>

</fetch>

One more thing, You can also create Advanced Find for your query and Download Fetch XML from there.

Mark this answer as Verified if it helps.

Thanks,

Himanshu Prajapati

Was this reply helpful? Yes No
Suggested answer

KARTHIKGOWTHAM@SUYA... 175 on at

Like (0)

Report

Hi MSCRM,

Here is a sample FetchXML query. Guess this is what you are looking for:

<fetch top="50" >

<entity name="contact" >

<filter type="and" >

<filter type="or" >

<condition attribute="firstname" operator="not-null" />
<condition attribute="lastname" operator="not-null" />

</filter>

<filter type="or" >

<condition attribute="emailaddress1" operator="not-null" />

<condition attribute="telephone1" operator="not-null" />

</filter>

</filter>

</entity>

</fetch>

Regards,

Karthik

Please mark as Verified, if you find this useful

Was this reply helpful? Yes No
Emre GULCAN 2,379 on at

Like (2)

Report

Hi,
Additional to Gopalan and Himanshu 's answers,
You can use XrmToolbox 's Fetchxml Builder plugin or directly prepare your query in MS CRM advanced find and download your query as fetchxml.

Was this reply helpful? Yes No
MSCRM learner 170 on at

Like (0)

Report

Hi Gopalan,

Thanks for your quick reply. It worked.

Was this reply helpful? Yes No
Suggested answer

MSCRM learner 170 on at

Like (0)

Report

Hi Himanshu,

Thanks for suggesting the way of Download FetchXML. Onwards I will follow the same.

Was this reply helpful? Yes No
MSCRM learner 170 on at

Like (0)

Report

Thanks Karthik for the answer.

Thanks Emre for letting me know about the plugin. I will download and install it in my CRM.

Was this reply helpful? Yes No