Sign in

Microsoft.com

Microsoft

Remove From My Forums

QueryExpression and SUM/GROUP BY

Question
0

Sign in to vote

Hi, I'm relatively new to CRM, I know when you send a request to the CRM Web Service, you can link entities using QueryExpression, ConditionExpression, FilterExpression, etc. It kinda simulates an sql inner join between tables. Lets say that I want to do something similar as a SUM/GROUP BY on a column of an SQL table, but instead I want to do it on an attribute of an entity, using the CRM Web Service. Does CRM offers a solution for that or do I have to do it on my own ?

Wednesday, May 13, 2009 4:23 PM

Answers

0

Sign in to vote
Hi Jean-Francois,

look here:

http://blogs.msdn.com/crm/archive/2009/03/10/support-for-count-distinct-in-fetch-xml-queries.aspx

Viele Grüße Michael Sulz axcentro GmbH
- Proposed as answer by Michael Sulz Wednesday, May 13, 2009 4:28 PM
- Marked as answer by Jean-Francois McNeil Wednesday, May 13, 2009 4:59 PM
Wednesday, May 13, 2009 4:28 PM

All replies

0

Sign in to vote
Hi Jean-Francois,

look here:

http://blogs.msdn.com/crm/archive/2009/03/10/support-for-count-distinct-in-fetch-xml-queries.aspx

Viele Grüße Michael Sulz axcentro GmbH
- Proposed as answer by Michael Sulz Wednesday, May 13, 2009 4:28 PM
- Marked as answer by Jean-Francois McNeil Wednesday, May 13, 2009 4:59 PM
Wednesday, May 13, 2009 4:28 PM
0

Sign in to vote

Thank you Michael.

I suppose if I want to add conditions to my request, I'd have to add filter/condition tags inside my xml query string ?

Wednesday, May 13, 2009 4:46 PM