Hello,

I want to have a report with detail below in a query, so that I can use this query directly to Servicedesk database, the reason why I ask this question becuase the built-in request exported to xls file have many merge cells thus I cannot use this file to filter or add formulas more.

 

Display column:

Request ID

Shop Code (this is new field I have added into my request template)

POS Area (this is new field I have added into my request template)

Subject

Category

SubCategory

Created Time

Completed Time

Time Spent

Resolution

Requester

Technician

Request Status

Amount

 

 

Date Filter:

Completed Time = Last month

 

 

Advanced Filtering

Technician is "Test"

Request Status is "Closed"

Assigned Technician is "Test"

Category is "POS"

Subcategory is "Open New POS"

POS area is "1"

 

 

Order by:

Created Time then Complete time then Shop Code

 

Please help to turn this report into a query sentence.

 

thank you !

Tai