[SDP MSP 8316] Query report of Archived Requests

Hello ME Team,

considering we cant export reports with the same fields in Active Requests from the Archive Requests, I would much appreciate if you could assist me with the following query report of Archive Requests.

For the audit of the ISO20K and ISO27K we need to be able to obtain certain information, that we have on Active, but not on Archive requests like:

Account

Requester

Request ID

Customer ID Reference

Subject

Created Time

Completed Time

Time Elapsed

Urgency

Category

Subcategory

Item

Group

Technician

Request Type

Request Mode

Request Status

Responded Date

Technician Displacement-

Escalated Manufacturer-

Manufacturer Case ID:

Escalated Enginnering-

RMA:

Resolution

Overdue Status:

First Response Status:

I have to be able to introduce a certain time range, and the dates format must be ok, and not on epoch format.

PS: some of this fields are custom additional fields:

UDF_CHAR10	Activated Techician on Call?	Text Field 10
UDF_CHAR12	Escalated Manufacturer?	Text Field 12
UDF_CHAR13	Escalated Enginnering?	Text Field 13
UDF_CHAR14	RMA:	Text Field 14
UDF_CHAR15	Manufacturer Case ID:	Text Field 15
UDF_CHAR17	Customer ID Reference	Text Field 17