Request Management - details of parent request and its dependent requests
This report returns the details of the parent request and its dependent requests.
SELECT wo.WORKORDERID "Request ID",
wo.TITLE "Subject",
ti.FIRST_NAME "Technician",
pd.PRIORITYNAME "Priority",
wo.CREATEDTIME "Created Time",
wo.DUEBYTIME "DueBy Time",
std.STATUSNAME "Request Status",
CASE
WHEN wos.ISOVERDUE='1' THEN 'Yes'
ELSE 'No'
END "Overdue Status",
wodm.Dependsonid "Depends on" FROM WorkOrder wo
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
LEFT JOIN SDUser td ON wos.OWNERID=td.USERID
LEFT JOIN AaaUser ti ON td.USERID=ti.USER_ID
LEFT JOIN PriorityDefinition pd ON wos.PRIORITYID=pd.PRIORITYID
LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID
INNER JOIN WODependency wod ON wo.workorderid=wod.workorderid
INNER JOIN WODependencyMarking wodm ON wod.Reqdependencyid=wodm.Reqdependencyid
WHERE (wo.ISPARENT='1')
Click this link to navigate to the next report.