How to add filter conditions to get report Incidents

Not applicable

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

Thanks

2 REPLIES 2

Dr Atul - LNG
Tera Patron

Hi @Community Alums 

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.

Not applicable

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