Common Interactive Filter Across Tables / Views

[Community Alums]

I am building a dashboard that has incident, problem and change reports on it.

All of the reports that are on the dashboard are based on different DATABASE VIEWS, with each view joining, for example the Incident table with task_cmdb_ci_service, and the change table and problem table in the same way on different views.

I want to add a SINGLE interactive filter - for example ENVIRONMENT for which we have a common choice list value from sys_choice.  I'm trying to avoid having to put 3 different filters on the report for each of the tables

My understanding from the documentation is that filters can be applied to views by using the 'Apply to both database views and tables' option.  I have ticked this as well as the 'Apply to all tables in hierarchy' option which I believe should be applying to both child and sibling relationships.

I have tried to build the interactive filter against the choice list based on the incident table.  This works for incident reports only (applying to the view correctly) but not applying to the problem or change reports (view); however if I create a separate problem report (on the problem table) it does apply.

I have also tried to build the interactive filter against the choice list on the task table and that doesn't apply to any.

Ideally, I'd like to have the ability to define this filter like I would with a reference so that I can map the different fields in different tables (actually this works for breakdowns but bizarrely not in an interactive filter)

Of course, I could build 3 filters out, but from a user experience perspective, they should really just be able to say, "show me everything relating to Production, show me everything against Development or Pre-production"

Does anyone know:

1)  Why my filter isn't applying an interactive filter to the related views (I was expecting the application to apply a combination of applying to all tables in the hierarchy and then applying to views - in that order)

2) If there is any other known method to create a single interactive filter value that works with views so I can create a single drop down box showing the different environments for selection?

p.s. I even tried the 'Group' filter type hoping it would combine the values from 3 different filters, but all it ended up doing is giving me the option to select 3 DIFFERENT values for 'Production' within the same filter box.

[sachin_namjoshi]

1)  Why my filter isn't applying an interactive filter to the related views (I was expecting the application to apply a combination of applying to all tables in the hierarchy and then applying to views - in that order)

--> Interacte filter works on relationship between tables. You will have to include all database views in your interactive filter reference table. 

2) If there is any other known method to create a single interactive filter value that works with views so I can create a single drop down box showing the different environments for selection?

--> Instead of multiple database view, you can configure 1 database view using Task table since task table is a parent table for incident, problem, change. If you want fields which are available only on extended tables e.g incident, still you can create 1 interactive filter and include all database view tables in your interactive filter reference like below

RRegards,

SSachin

[Community Alums]

Sachin,

Thank you for your reply. 

"--> Interacte filter works on relationship between tables. You will have to include all database views in your interactive filter reference table. "

This is what I have been doing for all REFERENCE based Filters, however, as this is a CHOICE LIST based filter, the interactive filter reference table tab does not appear.  I actually got this working in a breakdown just fine, but interactive filters it just doesn't seem to work with choice lists and I have no way to map to my view.

Are you saying that on your instance you can do this for choice list based filters?

---

"-> Instead of multiple database view, you can configure 1 database view using Task table since task table is a parent table for incident, problem, change."

Yes - I could go and do this but for a few reasons (including performance) I decided to have dedicated views against each process so I can define the exact fields that should be included and ensure the record count is optimal.

Ideally I'd still like to find a solution that allows me to create a single filter and apply it to all the views, especially since the views are based on child tables of task. 

[sachin_namjoshi]

You won't get interactive filter references for choice list type of filters.

Instead of configuring choice list filters, you can convert this choice list filter into reference type of interactive filters so that you can relate multiple database views to same reference interactive filter.

IF you see below, you need to check the checkboxes for applying same filter on extended tables and database views.

Regards,

Sachin