Worklog - "Time Taken to Resolve" field should not be 0 value
1. Under <PROD-HOME>/custom/scripts take a backup of CustomScript.js.
2. Download the CustomScript.js. and place it in the same folder
3. Clear the browser cache once and then try to add a worklog. You should get a warning message when both the fields have 0 value.
Points to be noted:
* This is only UI implemented validation which is applicable only for UI forms. Additions/modifications made through API or mobile app will not undergo this zero/null time spent validation.
* This validation is applicable for all work logs across all modules
* This validation will not be applicable if the work log is in Contract of Service Plan type Charge Per Hour
Ref.5597244
New to ADSelfService Plus?
Related Articles
Query to show total time taken to resolve and total time onhold ( MSSQL )
Tested in build MSSQL (14306) SELECT "wo"."WORKORDERID" AS "Request ID", "mdd"."MODENAME" AS "Request Mode", "qd"."QUEUENAME" AS "Group", "aau"."FIRST_NAME" AS "Requester", "cd"."CATEGORYNAME" AS "Category", "scd"."NAME" AS "Subcategory", ...How to add total_time_spent in worklog using API
Please use milli-seconds as value to the attribute URL: <URL>/api/v3/worklog?OPERATION_NAME=add&TECHNICIAN_KEY=XXXXXXXXXXXXX JSON: input_date={ "worklog": { "request": { "id": "6" }, "description": "Adding a worklog", "technician": { "name": ...Query to get total worklog time spent on a request. (PGSQL)
Tested in build PGSQL (14300) Scenario: Request1 worklog1-Total time taken to resolve=1 hr 20 mins. worklog2- Total time taken to resolve=1hr 10mins. While generating a report the total time taken to resolve for request1 should be 2 hrs 30mins. ...Script to Duplicate / Copy Response Due by time under Custom Additional field
Kindly follow below instruction to duplicate Response Due by time under Custom Additional Field. How to Setup Python * Download attached files and place it under Servicedeskplus-msp<home>\integration\custom_scripts * Edit Configuration.json file and ...Query to show the time taken between created time and first technician assigned time (PGSQL)
Tested in Build PGSQL (14300) or MSSQL (14306) Go to Reports-New Query Report and execute this query. PGSQL: SELECT wo.WORKORDERID "Request ID", aau.FIRST_NAME "Requester", LONGTODATE(wo.createdtime) "Created Time", LONGTODATE(wo.COMPLETEDTIME) ...