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')

          • Related Articles

          • Request recipient email

            This report is used to find the recipient email address.  Some requests are forward to others through the mail, this report helps to find the statistics how many requests are forward to others using the email address filter.  To make any changes to a ...
          • Service request approvers

             This report helps to find the who all the service request approvers in the application.  SELECT aaauser.first_name "Approver Name", dpt.deptname "Department", sdo.name "Site", sd.jobtitle "Job Title" FROM srapproverdetails LEFT JOIN aaauser ON ...
          • Automatically close request after successive approval reminders.

            This post describes the use of a python script to close requests after successive approval reminders using Custom Schedules. Use Case: We have an option under the self-service portal in order to send reminders mail for the approvals, what would be ...
          • Archived and Active Request in a same report

            This Report is used to get the complete list of request both active and archived request in the same report.  To make any changes to a query, refer to the KB article below. ...
          • How to create a new change request automatically from a request.

            This script is applicable only for builds prior to 11138. This is a sample python script that triggers the creation of a Change Request in ServiceDesk Plus using the Change API.The request ID of the parent request is appended  to the subject line of ...