Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

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