Script to Update date/time additional field inside request when note is added.

Script to Update date/time additional field inside request when note is added.

(Applicable for builds 14300 & above)
Please follow the below mentioned steps to configure:

First Download and extract the attached zip file containing the scripts & attachments (screenshots)

1.Goto Admin > Developer space --> Custom Functions > Global function > Click ''New'' > Copy and Paste the content from the attachment configuration.txt and save it with a name.

2.Update the URL and technician key in the script.   Refer to the attached screenshot.
Refer to the below link.

3.Go to Admin -->Developer space --> Custom Functions --> Note --Click ''New''> Copy and Paste the content from the attachment (3.update_additionalfield) and save it with a name.

4. Modify the global function name and additional field API name in the script. Refer to the attached screenshot. 

5. Configure Note custom trigger (as shown below)


NOTE: The script provided here will only update two days later.

                  New to ADSelfService Plus?

                    • Related Articles

                    • Script to Update Date additional field (to 3 days) based on priority inside the request

                      In some cases the customer will need to update the date additional field based on priority set inside the request. (Applicable for builds 14300 & above) Please follow the below mentioned steps to configure: First Download and extract the attached zip ...
                    • Close the request upon adding a note.

                      Kindly follow the steps mentioned below: 1) Go to Admin >> Developer Space >> Custom Function >> Global Functions >> Copy & Paste the attached GF_Content.txt and save it with a name. Update the URL and technician key as per your instance. Refer to ...
                    • Query to list out the notes added to the tickets

                      QUERY: To list of the notes added to the tickets  while generating report report SELECT  ti.FIRST_NAME AS "Support Rep", wo.WORKORDERID AS "Request ID", longtodate(wo.CREATEDTIME) AS "Created Time", wo.TITLE AS "Subject", aau.FIRST_NAME AS "Contact", ...
                    • Query to show last notes added in request (MSSQL & PGSQL)

                      Tested in Build PGSQL (14300) or MSSQL (14306) select wo.workorderid "request id", max(wo.title) "subject", max(qd.queuename) "group", max(std.statusname) "request status", max(pd.priorityname) "priority", max(sdo.name) "site", max(wo.createdtime) ...
                    • Send email notification to requester when a note is added to a request

                      How it works? A report will be scheduled to run at a periodic interval which will fetch he details of the request. Once the schedules runs, the script will fetch the values from the report and sends an notification through email to the requester of ...