How to show Business Elapsed % in list view of Incident Table without Database views

[Haseena Shaik]

Hi Team,

Is it possible to show Business Elapsed Percentage in list view of Incident table without creating Database views.

If Yes, Please let me know how to get that.

Thanks in Advance.

Regards,

Haseena

[RaghavSh]

"Business Elapsed Percentage" is a field on "task_sla" table so best possible solution is database views but there are other ways as well.

1. Create a custom field on incident table with name "Business Elapsed Percentage".

2. write a scheduled job which runs every 15 minutes ( or as per your requirement) which will glide the task_sla table and update the "Business Elapsed Percentage" from task_sla table to corresponding incident table.

Note:  Scheduled job may have performance impact based on the amount of data in your instance.

Please mark the answer correct/helpful accordingly.

[RaghavSh]

@Haseena Shaik did you get the solution for your question?

[RaghavSh]

@Haseena Shaik Is your issue fixed?

[Vedanti_]

I'm looking for same thing , to show Business Elapsed Percentage in list view of Incident table. I'm using ServiceNow as process user and have ITIL role associated with my account. @RaghavSh @AndersBGS Could please you suggest something on this situation.