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 ADManager Plus?

                  New to ADSelfService Plus?

                    • 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 ...
                    • Purchase Request details

                      Select pr.REQUESTID AS "Request Id", pr.SUBJECT AS "PR Subject", pr.DESCRIPTION AS "Description", LONGTODATE(pr.REQUESTEDDATE) AS "Requested Date", LONGTODATE(pr.DATEREQUIRED) AS "Date Required", LONGTODATE(pr.CREATEDDATE) AS "Created Date", ...
                    • 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. ...