Option to cancel the pending tasks when Request is cancelled- when the worklog is mandatory
Requirement:
Customer needs to close the tasks when the request is closed and the worklog is mandatory field in request closing rules.
Download the attached scripts.
Under Admin > Developer Space > Global Custom Function, create a new custom function. Paste the content of the Global Function script into the function.
Make sure to update the URL and technician key in the script. It's recommended to use a technician key with admin privileges to prevent any permission issues related to roles.
Under Admin > Developer Space > Request Custom Function, create another custom function. Paste the content of the "cancel tasks " script into this function.
- Under Admin > Custom Trigger > Notifications, configure a new Custom Trigger with the following settings:
The condition could be modified according to the specific requirements.
New to ADSelfService Plus?
Related Articles
Scripts to automatically cancel request tasks when the request status is set to cancelled (when the task closure rule is enabled)
NOTE: In the attached script Owner and Group value is hardcoded, so the script works only when the group and owner name are configured in task closure rules(valid technician name and group name). If technician and group doesn't exist inside the task ...Query to show both task comments and worklog comments ( MSSQL )
Tested in MSSQL build (14306) SELECT "taskdet"."TASKID" AS "Task ID", "taskdet"."TASKID" AS "Task ID", "wotask"."WORKORDERID" AS "RequestID", cd.CATEGORYNAME AS "Request Category", "taskgroup"."QUEUENAME" AS "Group", "taskowner"."FIRST_NAME" AS ...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 ...Script to Disable Worklog Addition on Closed Request
Kindly use the below scripts under Admin -> Page Scripts to disable Worklog addition on Closed request. The below script hides the Save option while creating new worklog on closed request. Script: let params=new ...Query to show both requests and task worklog time spent together ( MSSQL )
Tested in MSSQL build (14306) Timespent for both tasks and requests select wo.workorderid "Request ID", aau.FIRST_NAME "Requester", cast((((sum(ct.timespent))/1000)/3600) as varchar(20)) +'Hrs '+cast(((((sum(ct.timespent))/1000)/60)) % 60 as ...