CODEWITHSUNDEEP
dynamics-crm-2011dynamics-crmdynamics-crm-2013microsoft-dynamicsfetchxml
Matjaž
Matjaž

Reputation: 2115

FetchXml group by different values

I want to count Status Reason on Case entity. But I don't know how to group by as shown bellow. I was looking around but couldn't find anything useful.

------------------------------------
ALIAS       | STATUS REASON
------------------------------------
Open        | New
------------------------------------
In progress | In Progress
------------------------------------
            | Problem solved
Closed      | No customer response
            | Merged
            | Canceled
------------------------------------

There are some more Status Reason values, which I don't want to count.

Is this even possible?

Thanks!

Upvotes: 0

Views: 392

Answers (2)

Alessi
Alessi

Reputation: 769

I would suggest to retrieve the records using SSRS and perform the grouping in there. This would achieve both your requirements (i.e. grouping and exclusion of unwanted groups.)

Upvotes: 0

Henk van Boeijen
Henk van Boeijen

Reputation: 7938

According to the SDK it is in FetchXml only possible to Group by:

  • linked entities
  • year
  • quarter
  • month
  • week
  • day

When you cannot do without FetchXml (e.g. in reports on CRM OnLine) your only option is to get all data and do the grouping client side.

Upvotes: 1

Related Questions