FetchXML filter by EntityReference prop. Name

(0) Share

Report

Posted on by Community Member

Hi all.
I'm using fetchXML to fetch the data. I have EntityColection in result of _service.RetrieveMultiple(xml_query). Entity has attributes of type Microsoft.Xrm.Sdk.EntityReference. These attributes contain such properties "Id","Name","LogicalName".
Please, help me to build the correct query to set filters and orders by this fields.
For example, sql is like this:

SELECT Id, name, cur_price, manufacturerId_Name
FROM tb_goods WHERE cur_price > 10 AND manufacturerId_Name LIKE '%jumbo%'
ORDER BY manufacturerId_Name
LIMIT 10

I'm trying to make it on server (c#). Is it possible to use manufacturerId_Name in query directly ? Maybe it needs to use some chars like '/' , '|' ?

Thank you for any help

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Suggested answer

Bas van de Sande 4,383 on at

Like (1)

Report
Copy link

Link copied!

What you can do is the following: Use the Advanced Find within CRM. There you can create the query. Press the "FetchXML download" button and there you have the FetchXML needed :)

Was this reply helpful? Yes No
Suggested answer

Rajkumar Rajaraman on at

Like (1)

Report
Copy link

Link copied!

Hi Asgur,

Refer the following links:

social.microsoft.com/.../crm-2013-c-plugin-working-with-fetchxml-query

www.resultondemand.nl/.../273dd192-cc12-4ab0-84ec-1ea1b8f367c3.htm

Hope this helps.

Regards,

R. Rajkumar

Was this reply helpful? Yes No
Suggested answer

Mahadeo Matre 17,021 on at

Like (1)

Report
Copy link

Link copied!

advanced find is best option to generate fetchxml..

and you can convert your sql into fetchxml by using

http://www.sql2fetchxml.com/

Hope this will help

Was this reply helpful? Yes No
Verified answer

Royal King 27,686 on at

Like (2)

Report
Copy link

Link copied!

you could use fetchxml builder tool from Xrmtoolbox to build query and test result before using it in the code

https://fxb.codeplex.com/

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Thank you, guys !

I've just tried to use fetchxml builder - pretty nice tool!

PS

I didn't try Advanced search because it wasn't set on my server , maybe I missed something.

Was this reply helpful? Yes No