How to add filter conditions to get report Incidents

Research
Tera Guru

Hi 
How to add filter condition for OOTB report  in ui builder

Thanks

2 REPLIES 2

Dr Atul G- LNG
Tera Patron
Tera Patron

Hi @Research 

I recommend creating a database view for the task_sla and incident tables. This will allow you to filter tickets assigned to your group. In the task_sla table, you can use the 'business elapsed time' field and set it to 80% of the SLA target to filter the relevant tickets.

*************************************************************************************************************
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.

Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]

****************************************************************************************************************

priyatam_pvp
Tera Guru

Refer to the below SS, use the Task SLA Table or create a script include using the below task_sla query, return the incident numbers, and use the script here.

priyatam_pvp_0-1740753758282.png

Script Include using in filter

priyatam_pvp_1-1740753998182.png

 


Please Mark it helpful
Regards
Priyatam