Is it possible to report on the task_sla table where the incident has a specific tag?

[Steven Watts2]

Hi,

I'm trying to report on the task_sla table where my task type is Incident and that Incident has been tagged with a specific tag.

I haven't been able to do this OOTB so am wondering if anyone else has meet this requirement before? Suspect it's possible via a database view but am trying to avoid that option if their is way of acheiving this directly on the task_sla table.

My filter would be something like:

sla_definition.target IS resolution

active IS true

task.task_type IS incident

tag IS tagName (Name of tag i'm trying to report on)

Steven

[Ahmmed Ali]

Hello @Steven Watts2 

You need to add condition as task.tag is TAG_NAME. It is working for me. 

Thank you,

Ali

[Steven Watts2]

Hi @Ahmmed Ali 

Thanks for responding.

I can't see an option for task.tag when trying this in a report, see below:

I've tried the above, screenshot you provided, and it works fine however I need to access the tag via a report rather than filtering the table directly. 

Steven

[Ahmmed Ali · Accepted solution]

Hi @Steven Watts2 

This is weird that the filter is available in list view but not in report view.

Two workarounds:

1. Set the condition in task_sla list view as required, then right click on stage/type/definition any field and select bar chart, it will open report with the condition selected same as list view. you can just update report type and save it.

2. You can create report with required condition without tag condition. Then go to sys_report table and open the report you created. Then you can update the condition there to include the tags condition.

Thank you,

Ali

[Steven Watts2]

Thanks @Ahmmed Ali 

At least it wasn't just me who noticed the issue. Workaround 1 has worked great, thanks again for all your help. 

Steven