SD Version 8026

 

Hi Support,

 

Please could you assist me in creating a MSSQL query to run a report that contains the following;

 

All pending requests with the below columns including an extra column at the end that shows the last time a technician updated the request as shown in the history. (Including adding a note, Work Log or Conversation) The data also needs to be grouped by Technician Group.

 

 

 

 

Any assistance would be greatly appreciated.

 

Thanks In Advance.

Gary