Linked request
This report is used to find the child request id that are linked to the parent request id.
To make any changes to a query, refer to the KB article below.
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
Note : Login to ServiceDesk Plus, go to Reports tab > New Query Report > Copy the query to the query editor and run the report.
New to ADSelfService Plus?
Related Articles
How to close linked requests when a parent request is closed.
This post describes the use of a python script to close all the linked request when a parent request is closed using custom triggers. Use Case: We get tickets which are getting reported for the same issue but different end-users so that once we ...Query to show parent and child requests (Linked Request) and its details.(MSSQL & PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) Please go to Reports-New Query Report and execute this query. select woparent.WORKORDERID "Parent request ID", aaauparentreq.first_name "Parent Requester", woparent.title "Parent Subject", ...Close parent request only if all the linked request are closed.
Requirement: Parent ticket can be closed only if all the linked requests are closed Usecase: In many organizations, the parent ticket is divided into many sub-requests, each of which is handled by a different technician/group. All of these ...Close all linked requests when a parent request is closed - Deluge
Requirement: All the linked requests need to be closed when the parent request is closed. Refer to this link for Python equivalent: https://pitstop.manageengine.com/portal/en/kb/articles/how-to-close-linked-requests-when-a-parent-request-is-closed ...Update request additional field with Custom Request ID
Requirement: Each Organization's request ID format may differ. In the current model, replacing the existing request id with these is not possible; however, the same can be replaced in an additional field. Custom Format : Example: 202305221125001 ...