Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Should I use queryexpr...

Should I use queryexpression or FetchXML for complicated Dynamic CRM 365 project?

(0) Share

Report

Posted on by Community Member Microsoft Employee

I need to transfer a CRM 4.0 "project" to CRM 365. I have already transferred the data and create all forms. The main "program" in 4.0 is a .dll plugin involve few sql in it, each sql includes multiple "group by", "join". There is an update sql query as well. The .dll includes a complicated customized "view" from sql server. Then this .dll would call a report rdl, in the rdl there are more sql and call a stored procedure. Finally a report would be generated.

I need to do this fast so plan to do all of these in a asp.net program. I think I can either use queryexpression or FetchXML. But look like queryexpression doesn't support "group by" that kind of aggregate functions so it looks like FetchXML is easier. But FetchXML seem like has no debug at all.

Any suggestion? Thanks.

*This post is locked for comments

All responses (1)

Answers (0)

Suggested answer

unizap on at

Like (0)

Report

RE: Should I use queryexpression or FetchXML for complicated Dynamic CRM 365 project?

Hi,

If you have Group By in your queries- go for FetchXML. You can test your queries here- http://msxrmtools.com/fetchxml

You may also download XrmToolbox which has FetchXML tester plugin

https://www.xrmtoolbox.com/