Please assist on the creation of interactive filter from the task_sla table

[Ken61]

Hello All,

I need an assistance in creation of interactive filter from the task_sla table.

Requirement is to create interactive filter from the task_sla table with the following condition.

Table: Task SLA (Task Type is Problem)

   - Problem Opened - Single.

The filter was created but I am having issue creating the interactive filter references because I always get an error. Below is the screen shot for the interactive filter that was created.

Please assist on the best way to get this done

Interactive filter reference

[Laszlo Balla · Accepted solution]

If you want to filter by SLA definition, you should create the interactive filter on the 'contract_sla' table and not on task_sla. Then in the 'Interactive Filter References' tab, you can map this to the corresponding field your report is based on.

[Ken61]

@Laszlo Balla Thanks for a quick response. Can the interactive filter reference tab to map to task from task_sla table?

[Laszlo Balla]

No, contract_sla table has no reference to tasks. You need to map the filter to the 'sla' field on the task_sla table.

This will work if you want to filter by SLA, which I am only guessing based on your previous post.