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. ...How to auto-create worklog based on values specified in the request
This post will to help you create a worklog automatically when a request is created. This script can be configured under Request custom triggers and you will find more information about this here. This is achieved using an API call to create a ...Query to retrieve worklog details
Tested in: 14610 (Postgres) Query: SELECT wo.WORKORDERID AS "Request ID", aau.FIRST_NAME AS "Requester", sdo.NAME AS "Site", ti.FIRST_NAME AS "Request Technician" ,au1.FIRST_NAME AS "Worklog Technician", TO_CHAR(((sum(ct.TIMESPENT))/1000 || ' ...