Version : 14300

DB:PGSQL / MSSQL

Query :

SELECT wo.WORKORDERID AS "Request ID",
au.FIRST_NAME AS "Created By",
LONGTODATE(wo.createdtime)  AS "CREATEDTIME",
qd.QUEUENAME AS "Group",
std.STATUSNAME AS "Request Status",
ti.FIRST_NAME AS "Support Rep",
LONGTODATE(si.ENDTIME) OPERATIONTIME,
sisd.queuename as "Changed From",
sinsd.queuename as "Changed To",
aaa.FIRST_NAME "PERFORMEDBY" FROM WorkOrder wo
LEFT JOIN WorkOrderstates wos ON wo.WORKORDERID = wos.WORKORDERID
LEFT JOIN WO_Assessment woas ON wo.WORKORDERID = woas.WORKORDERID
LEFT JOIN SDUser td ON wos.OWNERID=td.USERID
LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID
LEFT JOIN WorkOrder_Queue woq ON wo.WORKORDERID=woq.WORKORDERID
LEFT JOIN QueueDefinition qd ON woq.QUEUEID=qd.QUEUEID
LEFT JOIN WO_GROUP_INFO si ON woas.ASSESSMENTID = si.ASSESSMENTID
LEFT JOIN QueueDefinition sisd ON si.GROUPID = sisd.queueid
LEFT JOIN QueueDefinition sinsd ON si.NEXTGROUPID = sinsd.queueid
LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID
LEFT JOIN AAAUser aaa ON si.operationownerid = aaa.USER_ID
LEFT JOIN SDUser sd ON wo.requesterid=sd.USERID
LEFT JOIN AaaUser au ON sd.USERID=au.USER_ID
 WHERE(wo.ISPARENT = '1' and si.NEXTGROUPID IS Not Null )  order by 1