Database view and interactive filters

[Michele Conz1]

Hello all.

I'd like tu use an interactive filters (OOTB) on a custom dashboard in order to filter a custom report ( a bar chart) that shows data from a database view (OOTB, incident_sla), but it doesn't work.

All the necessary checks are flagged.

Do the interactive filters work only on table-based report e not for database view-based report?

Thanks in advance

[Ankit P · Accepted solution]

Interactive filters do work on Database views but you need to add Interactive Filter Reference for that database view.

Below the interactive filter form, you will see a related list "Interactive Filter Reference", click on New, select the database view in the reference table and reference field on which you want to filter.

Mark correct if that helps.

[eamoncampbell]

Should Interactive filters based on Choice Lists also work on Database views ? The use case I a looking at is not working as expected.

[Alec Hanson Bay]

Yes they do work but you need to select the appropriate Tick box on the Choice List Interactive Filter

https://docs.servicenow.com/bundle/newyork-performance-analytics-and-reporting/page/use/reporting/ta...