How to add filter conditions to get report  Incidents
						
					
					
				
			
		
	
			
	
	
	
	
	
- Mark as New
 - Bookmark
 - Subscribe
 - Mute
 - Subscribe to RSS Feed
 - Permalink
 - Report Inappropriate Content
 
ā02-28-2025 06:29 AM - edited ā03-10-2025 01:40 AM
Hi 
How to add filter condition for OOTB report  in ui builder
Thanks
- Mark as New
 - Bookmark
 - Subscribe
 - Mute
 - Subscribe to RSS Feed
 - Permalink
 - Report Inappropriate Content
 
ā02-28-2025 06:42 AM
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]
****************************************************************************************************************
- Mark as New
 - Bookmark
 - Subscribe
 - Mute
 - Subscribe to RSS Feed
 - Permalink
 - Report Inappropriate Content
 
ā02-28-2025 06:46 AM
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.
Script Include using in filter
Please Mark it helpful
Regards
Priyatam
