Microsoft Dynamics 365 | Integration, Dataverse...

Passing current contact to a complex query

(1) Share

Report

Posted on by wigneys1

Hi,

I have a complex query that returns a list of projects that a contact is related to. To return the list of projects, I have a fairly complex fetchxml query that i want to pass the current contact to as a filter expression, how do I do this?

cheers

Steve.

All responses (5)

Answers (0)

Sort by

André Arnaud de Cal... 307,801 Super User 2026 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi wigneys1,

Can you tell us for which exact Dynamics 365 application you are seeking help on this forum?
wigneys1 21 on at

Like (0)

Report
Copy link

Link copied!

It's a model driven app built on Dynamics 365 Sales Enterprise...
André Arnaud de Cal... 307,801 Super User 2026 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Thanks for your reply. I'm not able to help with this. Let's wait for another volunteer to chime in.
MH-16081421-0 11 on at

Like (0)

Report
Copy link

Link copied!

Hi Steve.

"I want to pass the current contact to as a filter expression" sounds like you are trying to create a generic FetchXML. Is this correct? If so, would you mind posting the FetchXml? At least the relevant parts would help.

Michael
Suggested answer

SeanRoque 4 on at

Like (0)

Report
Copy link

Link copied!

If you're talking about using a QueryExpression in your code and you want to pass your fetch as a filter, you can use the SDK FetchXmlToQueryExpressionResponse to convert your fetchxml string (use string format to include your current contact id) to a QueryExpression and use that. See this post on how you might go about doing that https://community.dynamics.com/blogs/post/?postid=3f01c4e7-2113-4a1b-b728-e7d2d6362c71

If you just want a way to retrieve the list of projects, I recommend the XrmToolBox tool "Export To Excel" https://www.xrmtoolbox.com/plugins/Ryr.XrmToolBox.ExportToExcel/ has a button that utilizes another tool "FetchXML Builder" https://www.xrmtoolbox.com/plugins/Cinteros.Xrm.FetchXmlBuilder/ to let you edit the fetch, and extract records as a spreadsheet.