Interactive Filter on application table
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-18-2022 08:23 AM
I have a dashboard with a report on it, of a list of my organizations applications and their related information. I'd like to add an interactive reference filter so that the list can be searched by application name, which is the first column in the report.
I've tried making the interactive filter but I can't get the right Interactive Filter References to work properly.
When making the filter for "Reference Table" I use "Application" [cmdb_ci_appl]. This generates the list of application names I want in the default value preview screen.
But I don't know what to fill out for the Interactive Filter Reference tab.
Has anyone tried this before?
Thanks

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-14-2022 05:50 PM
Hi Trent,
Unfortunately, the cmdb_ci_appl.name field you want to use is a String field, and Interactive filter cannot use a String field.
You will need to create a Custom Interactive Filter.
Although I have never created one myself, here is the documentation: https://community.servicenow.com/community?id=community_blog&sys_id=aaedd2b7db5480d45129a851ca961988
JP