How to retrieve result data from Dynamics 365 multiple entities using a single query in C#?

(0) Share

Report

Posted on by CRMJetty

3,512

Hi All,

In a recent project, we have a requirement for search data from multiple entities. I want query results from multiple entities using QueryExpression or FetchXml in a single query in Dynamics 365. Is there any way to do this or how can I achieve this?

I would really appreciate if you could share any useful resources on this.

Thank you

I have the same question (0)

All responses (1)

Answers (0)

Suggested answer

prt33k 6,907 on at

Like (1)

Report
Copy link

Link copied!

Hi Maulik,

No straight forward way to achieve this.

FetchXml/QueryExpression can return result of only single entity type. You can join linked entity, add column of those linked entity to your search but the result will return entity of only one type. Union of fetch is not supported.

One other option is to look into global search - though it is not a documented method but it does work however you wont be able to get support.

dreamingincrm.com/.../

Thanks,

Prateek

Was this reply helpful? Yes No