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
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 ...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 ...How to automatically create multiple tasks in a change request with a configurable JSON file.
Note: Attached script will not work beyond 11138 SDP Version. This is a sample Python script to automatically create multiple tasks within a change request with a configurable JSON file. This is achieved using an API call to create a task in ...Set Task Owner depending on the request site
Requirement: Set Task Owner depending on the request site. Usecase: When a task is triggered from a request, it should be assigned to a technician depending on the request site. Steps to follow: Goto Admin > Task Custom Functions > Global function > ...