Hello,

We've recently migrated to the cloud version of Service Desk from on-premise, I'm trying to configure my timespent reports, but various fields are missing and wondering if it was something that will be possible to add the following fields to the selector in the near future or does anyone know how to include it in the reports for the cloud version?

The query of the original report is as per below, but I couldn't find query options in the cloud version of servicedesk:

SELECT wof.UDF_CHAR10 AS "Company", wof.UDF_CHAR10 AS "Company", wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", wo.TITLE AS "Subject", ct.DESCRIPTION AS "Time Spent Description", ct.TIMESPENT AS "Time Spent", ct.TS_STARTTIME AS "Time Spent Starttime", ct.TS_ENDTIME AS "Time Spent Endtime", ct.TECH_CHARGE AS "Time Spent Tech Charge", ct.OTHER_CHARGE AS "Time Spent Other Charge", ct.TOTAL_CHARGE AS "Time Spent Total_Charge" FROM WorkOrder wo LEFT JOIN WorkOrderToCharge wotoc ON wo.WORKORDERID=wotoc.WORKORDERID LEFT JOIN ChargesTable ct ON wotoc.CHARGEID=ct.CHARGEID LEFT JOIN SDUser rcti ON ct.TECHNICIANID=rcti.USERID LEFT JOIN AaaUser rctd ON rcti.USERID=rctd.USER_ID LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrder_Fields wof ON wo.WORKORDERID=wof.WORKORDERID WHERE  (((rctd.FIRST_NAME = 'Katsi') AND (((wof.UDF_CHAR10::TEXT != 'LSBM Ltd'::TEXT) AND (wof.UDF_CHAR10::TEXT != 'LSBM Salon'::TEXT)) OR (wof.UDF_CHAR10::TEXT IS NULL))) AND (((ct.TS_STARTTIME >= 1595545200000) AND ((ct.TS_STARTTIME != 0) AND (ct.TS_STARTTIME IS NOT NULL))) AND ((ct.TS_STARTTIME <= 1595631599000) AND (((ct.TS_STARTTIME != 0) AND (ct.TS_STARTTIME IS NOT NULL)) AND (ct.TS_STARTTIME != -1)))))  AND wo.ISPARENT='1'  ORDER BY 1 NULLS FIRST , 8 NULLS FIRST 

Thanks in advance.