Currently here is my query
SELECT serdef.NAME "Service Category",serdef.NAME "Service Category",wo.WORKORDERID "Request ID",aau.FIRST_NAME "Requester",wotodesc.FULLDESCRIPTION "Description",appStDef.STATUSNAME "Approval Status",wo.TITLE "Subject" FROM WorkOrder wo LEFT JOIN SDUser sdu ON wo.REQUESTERID=sdu.USERID LEFT JOIN AaaUser aau ON sdu.USERID=aau.USER_ID LEFT JOIN WorkOrderToDescription wotodesc ON wo.WORKORDERID=wotodesc.WORKORDERID LEFT JOIN ServiceDefinition serdef ON wo.SERVICEID=serdef.SERVICEID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID LEFT JOIN ApprovalStatusDefinition appStDef ON wos.APPR_STATUSID=appStDef.STATUSID WHERE ((serdef.NAME = 'Security Request') AND (((wo.CREATEDTIME >= datetolong('1265004000000') AND ((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL))) AND ((wo.CREATEDTIME <= datetolong('1360735199000') AND (((wo.CREATEDTIME != 0) AND (wo.CREATEDTIME IS NOT NULL)) AND (wo.CREATEDTIME != -1))))) AND wo.ISPARENT=1 AND wo.IS_CATALOG_TEMPLATE=1 ORDER BY 1
I would like to add an Employee Name field:
19 ServiceReq_User UDF_CHAR1 Employee Name Text Field 1 Single Line
Any help would be appreciated.