Show business elapsed percentage on incident list view

Khalnayak · ‎02-04-2021

Hi,

I have a requirement to display the Business elapsed percentage field on the incident list view.

the field is related list on the incident table and is from the task sla table.

so i have this displayed as a related list within the incident form, but I need this displaying in the list view on incidents like below. so it should bee at the far right displaying the same bar like percentage.

How can I achieve this please?

Ankur Bawiskar · ‎02-05-2021

Hi,

another easy method

1) create reference field on incident table

a) Name - u_task_sla

b) Type - reference

c) Referred to - task_sla

2) Now on the incident list you can dot walk the new field and add the business percentage field via dot walking

3) Remember to populate this new field after insert of task_sla

Condition: current.task.sys_class_name == 'incident'

Script:

(function executeRule(current, previous /*null when async*/) {

    // Add your code here

var inc = new GlideRecord('incident');

inc.get(current.task);

inc.u_task_sla = current.sys_id;

inc.update();

})(current, previous);

Regards
Ankur

Regards,
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader

View solution in original post

Suseela Peddise · ‎02-04-2021

Hi,

Business elapsed percentage is on task_sla table and you cannot view this field information on incident table list view.

Alternatively , you can access 'incident_sla' table to view incident and SLA details both in list view.

If I have answered your question, please mark my response as correct and/or helpful.

Thanks,

Suseela P.

Khalnayak · ‎02-04-2021

Hi @Suseela Peddisetty please can you tell me how to add the incident_sla tables business percentage like in your screenshot

Suseela Peddise · ‎02-04-2021

Hi,

Table is already exists. To open table list, type 'incident_sla.list' in filter navigator and press enter . See below image.

And then add field to the list ,Click the list title menu icon and select Personalize List Columns. Use the slushbucket to select the columns and the desired order.

See below docs to add columns to list

https://docs.servicenow.com/bundle/paris-platform-user-interface/page/use/using-lists/task/t_Persona...

https://docs.servicenow.com/bundle/paris-platform-user-interface/page/use/using-lists-v3/task/t_Pers...

If I have answered your question, please mark my response as correct and/or helpful.

Thanks,

Suseela P.

Suseela Peddise · ‎02-05-2021

Hi @Usmaan ,

Did my reply answer to your question or is there more information I can help you with?

If so, please mark the above response as correct so that the question will appear as resolved for other users who may have a similar question in the future.

Thanks,

Suseela P.