Report Request - Merged Tickets
We have this merge request SQL query
select Workorderid "Parent Request" , (SELECT STUFF((SELECT cast(Child_woid as varchar) + char(10) FROM conversation co where conversation.Workorderid=co.Workorderid FOR XML PATH ('')), 1, 0, '')) "Merged Request" from conversation where Child_woid is not NULL AND CREATEDTIME >= <from_today> AND CREATEDTIME <= <to_today> group by Workorderid
We would like to request one that shows the same information but would like to be able to run this against a specific group, we would want it to return Group Name, Subject, Created Time, Resolved Time, Technician.
Regards Luke