Request Management - report to get information on linked requests

Linked requests - to find the child request ID that are linked to the parent request ID.

To make any changes to this query, refer to this post.

SELECT wos.linkedworkorderid "Request ID",
       wo.TITLE "Subject",
       std.STATUSNAME "Request Status",
       rtdef.NAME "Request Type",
       longtodate(wo.CREATEDTIME) "Created Time",
       wo.workorderid "Linked to" FROM WorkOrder wo
LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID
LEFT JOIN RequestTypeDefinition rtdef ON wos.REQUESTTYPEID=rtdef.REQUESTTYPEID
LEFT JOIN StatusDefinition std ON wos.STATUSID=std.STATUSID
WHERE (wo.ISPARENT='1')
  AND wos.linkedworkorderid IS NOT NULL
ORDER BY 1