Request Dependency
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')
New to ADSelfService Plus?
Related Articles
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 ...Update Requester from Request Description
Use case: When a request is submitted on behalf of a user via email, the request description contains the requester's full name. Script to update the ticket requester accordingly. Tested on builds: 14306,14500. Steps to follow: Go to Admin > Request ...Request missing
Use case: In some cases, requests are missing. We would get the ID number from acknowledgement notification but we cannot find that in the tickets. In such cases, please follow below steps to find out the details. 1. Make sure to check the Request ...Change Conversation as "Private" when the external user replies to the Request
Recently one of our customers had the requirement to change the conversation to "Private" when the external user replies to the request. Customer's workflow: The request is created by a user who is inside the application. Now the admin is forwarding ...Query to get the Request First Assigned time
Use case: First Assigned Time is the number of minutes, hours, or days between when a requester submits a request and when was a support representative assigned to the Request. It indicates how long it is in an unassigned state. Working on Build: ...