Request Dependency

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 M365 Manager Plus?
      New to M365 Manager Plus?
        New to RecoveryManager Plus?
        New to RecoveryManager Plus?
          New to Exchange Reporter Plus?
          New to Exchange Reporter Plus?
            New to SharePoint Manager Plus?
            New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                    • Related Articles

                    • Document for Request Custom Menu and Custom Triggers

                      Attached a PDF file explaining with screenshots on how Request Custom Menu & Custom Triggers work.  

                    • Duplicate Request

                      Usecase: Script to duplicate the request in a single click using Callback Function and Page Script. Steps to configure: Download the attached files Login to SDP and navigate to Admin > Developer Space > Global Function > Copy & Paste the attached ...

                    • Establishing Field Dependency in ServiceDesk Plus Using CSV Data and Field/Form Rules

                      This Knowledge Base article outlines the process of establishing field dependency in ServiceDesk Plus using CSV data and Field/Form Rules. By following these steps, administrators can enhance the flexibility and efficiency of form interactions, ...

                    • Script: Acknowledge User by e-mail when the request is updated (with changed value)

                      We can achieve it by using the Custom Trigger feature along with a python script. We can set a trigger based on which the script will execute. As the notification needs to be sent when there is an update in the Request fields. It's better to save the ...

                    • 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 ...

                      Related Products