Trigger a set of tasks
Requirement:
Auto Trigger a set of task associated to a request depending on the date configured in the request additional field.
Steps to follow:
- Goto Reports > New Query Report > execute the query and save it with a name.
- PGSQL:
- SELECT wo.helpdeskid "portalid",wo.WORKORDERID AS "workorderid", taskdet.TASKID AS "taskid" FROM WorkOrder wo LEFT JOIN Workorder_fields wof ON wo.WORKORDERID=wof.WORKORDERID LEFT JOIN WorkorderToTaskdetails wotk ON wo.WORKORDERID=wotk.WORKORDERID LEFT JOIN TaskDetails taskdet ON wotk.TASKID=taskdet.TASKID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID WHERE (taskdet.MODULE='request' and wo.ISPARENT='1') and (extract(epoch from(now()::TIMESTAMP - to_timestamp(wof.UDF_DATE1/1000)::TIMESTAMP))/3600/24 >= 0 and extract(epoch from(now()::TIMESTAMP - to_timestamp(wof.UDF_DATE1/1000)::TIMESTAMP))/3600/24 <1 )
- MSSQL:
- SELECT wo.helpdeskid "portalid",wo.WORKORDERID AS "workorderid", taskdet.TASKID AS "taskid" FROM WorkOrder wo LEFT JOIN Workorder_fields wof ON wo.WORKORDERID=wof.WORKORDERID LEFT JOIN WorkorderToTaskdetails wotk ON wo.WORKORDERID=wotk.WORKORDERID LEFT JOIN TaskDetails taskdet ON wotk.TASKID=taskdet.TASKID LEFT JOIN WorkOrderStates wos ON wo.WORKORDERID=wos.WORKORDERID WHERE (taskdet.MODULE='request' and wo.ISPARENT='1') and (DATEDIFF(day, dateadd(s,datediff(s,GETUTCDATE() ,getdate()) +(wof.UDF_DATE1/1000),'1970-01-01 00:00:00'),GETDATE()) >= 0 and DATEDIFF(day, dateadd(s,datediff(s,GETUTCDATE() ,getdate()) +(wof.UDF_DATE1/1000),'1970-01-01 00:00:00'),GETDATE()) <1 )
- Execute the query and save the report with a name. [Report name: trigger_task]
- Goto Admin > Custom Schedule Function > Global function > New > Paste the content from the attachment Global function_4.txt and save it with a name.
- Update the URL and integration key in the script.
- You can get the integration key under Admin > Integrations > Integration Key > New
- Please use an integration key with admin privilege, as there wont be any role related permission issues.
- Update the integration key in the global function.
- Goto Admin > Custom Schedule Functions > New > Paste the content from trigger_task.txt and save it with a name
- Refer to the attached script. (trigger_task.txt.)
- Update the global function count in the script as per your instance.
- Configure a custom schedule to invoke the created custom function with the query report as parameter.
- Note: We can configure this on repeat mode if the task count is huge.
New to ADSelfService Plus?
Related Articles
Scripts to cancel tasks when the request status is set to cancel
Applicable above 14000 builds Steps to configure: 1. Download the attached scripts and extract it. 2. Go to Admin >> Developer Space >> Global Function >> Copy & Paste the attached GF_Content.txt as shown in GFConfiguration.txt and save it with a ...Add and trigger predefined tasks to a request
Requirement: Add a set of tasks to a request and trigger them all at once. Steps to configure: Goto Admin > Developer Space > Global function > New > Paste the content from the attachment GF_4 - Configuration.txt and save it with a name. Update the ...Script to set Request Technician as the Task Owner for all associated tasks - Deluge
Requirement: Request technician should be set as the task owner for all available tasks. Use case: When the request is updated with the technician, all the associated task needs to be assigned to the same technician. Python ...Set SLA automatically for a service request using FAFR
Note: The below FAFR script will work only on 10600 MSP and above Requirement: Set SLA automatically for a service request depending on the Priority. Usecase: Let us consider a scenario where SLA has to be set depending on the requester's associated ...Script to set Request Technician as the Task Owner for all associated tasks.
Use case: Request owner should be set as the task owner for all available tasks (or only open) from the request menu option (or trigger) Prerequisites: 1. Python Installation Steps ...