Indicator condition to get all incidents where sla definition contains specific word

[JohnDF]

Hi everyone,

I'm setting up an indicator to retrieve all incidents. I want to filter these incidents so that only those with "xyz" in their sla_definition.name field are displayed. How can I achieve this? Specifically, how do I use dot notation within the indicator's condition to access the sla_definition.name?

Any guidance would be greatly appreciated. Thanks!

[ShubhamGarg · Accepted solution]

Hello @JohnDF ,

SLA definitions are defined in contract_sla table, whereas the history of incidents to whom the SLA gets attached is stored in task_sla table.

Table -> task_sla

Query -> task.sys_class_name=incident^sla.nameLIKExyz

It will retrieve you the task_sla records which got created for incident table records where sla name contains xyz. Hope it answers to your question.

If my response helps you in any way, kindly mark this as Accepted Solution/Helpful and help in closing this thread.

Regards,

Shubham