Case Report with Who Resolved The Case

(0) Share

Report

Posted on by ChrisJC

1,540

I'm trying to create an SSRS report of cases that includes a column with who resolved the case.

This is causing an issue where the case was reopened and subsequantly resolved again because my fetchXML is giving me two rows.

Can I reconfigure my fetchXML to only show the last person who resolved the case, am I looking at this the wrong way, or do I need to create a sub-report that will run for each case in the main report?

<fetch distinct="true" >
  <entity name="incident" >
    <attribute name="title" />
    <attribute name="accountid" />
    <order attribute="title" descending="false" />
    <filter type="and" >
      <condition attribute="statecode" operator="eq" value="1" />
      <condition attribute="createdon" operator="on" value="2018-11-15" />
    </filter>
    <link-entity name="incidentresolution" from="incidentid" to="incidentid" link-type="outer" alias="ae" >
      <attribute name="modifiedby" />
    </link-entity>
  </entity>
</fetch>

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

ChrisJC 1,540 on at

Like (0)

Report

RE: Case Report with Who Resolved The Case

For anyone who comes across this, I was previously using the modifiedby of the incidentresolution which was different. It seems in closing the case for the second time, the owner of the first case resolution is assigned to the second user. In this instance using the ownerid and distinct as true resolved the issue