Bulk close Purchase Orders - Python
Requirement: Delete older Purchase Orders. UseCase: Closing Purchase Orders from a external CSV. Please follow the below steps. Extract the attached scripts in a folder. Update the URL and integration key in the script. You can get the integration ...
Requirement: Delete all tasks. UseCase: Deleting tasks with task id less than a particular count. Please follow the below steps. Goto Reports > New Query Report > execute the query and save it with a name. select taskid, helpdeskid "portaild" from ...
Close requests with pending approval for more than 10 days
Requirement: Close older requests with pending approvals. UseCase: Close all requests for which approvals have been sent but no action has been taken in more than 10 days. Please follow the below steps. Goto Reports > New Query Report > execute ...
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 ...
Deluge Custom Function - Custom Schedules
Sample Scripts for custom schedule. Steps to configure: 1. Copy the respective query and save the query report with a name. 2. Update the query report name in the custom schedule function script. 3. Configure a custom schedule with the custom ...