Dot walk for interactive filter of type choice list

[Vespertinus]

Sample:
Reports on Dashboard are all based on task_sla table that has a reference filed to task table that is parent of incident table.

Interactive filter points to a choice list field on incident table (e.g.incident_state). No additional connection can be setup here (like for reference filters)
If a interactive filter is added like that to the dashboard it does not filter the reports correctly.

(this is only a sample, the date we use is diffrent and other tables, but its same problem here)

Is it possible to dot walk for interactive filter of type choice list?

[Ratnakar7]

Hi @Vespertinus ,

Yes, it is possible to use dot walking for interactive filters of type choice list. Here's an example of how to do it:

Let's say you have an interactive filter on the incident_state field, and you want to filter reports on the dashboard based on the task_sla table's reference to the task table that is the parent of the incident table. You can use dot walking in the filter condition of the report to achieve this.

For example, if you want to filter the report based on task_sla records that have an incident_state of "Closed", you can use the following filter condition:

task_sla.task.incident.incident_state=3

In this example, "task_sla.task.incident" is the dot walking path from the task_sla table to the incident table, and "incident_state" is the field on the incident table that you want to filter on. The "=3" at the end is the value of the "Closed" state in the incident_state choice list.

You can adjust the dot walking path and field name to fit your specific data model and choice list values.

Thanks,

Ratnakar

[Community Alums]

Hi @Vespertinus ,

You can build your report and filters on the existing incident_sla database view, or create one from scratch to join the incident and task_sla tables. Then build your report and interactive filters on that database view. 

Best regards,

Victoria