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
Document for Request Custom Menu and Custom Triggers
Attached a PDF file explaining with screenshots on how Request Custom Menu & Custom Triggers work.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 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 ...Mark Request as Non-Billable
You can make use of Business Rules to set the Criteria as "Request Type is" (or any Criteria as per yours) and under Actions set "Mark Request as Non-Billable". So once the Request is marked as Non-Billable, the worklog added under that request will ...