Custom interactive filter for text search not working
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-07-2023 02:23 PM
I need to be able to create a custom filter for a dashboard that allows a user to search on the short description instead of the number for a reference filter. In this case, the need to be able to search for a Demand's short description (name) instead of the number - which is what is available if I create a reference interactive filter.
I've searched the community and have found lots of posts, including the one with a link to K19's creator con, and I've copied them exactly but my code doesn't do anything. I've also checked the examples in the documentation, still doesn't work. I've noticed all of these posts are pre-San Diego and Polaris, I'm wondering if they are no longer valid and I need to be doing something else?
Here's what I've done:
1. Created a test dashboard and added a test report based on the Demand table (dmn_demand). It's just a simple list report, nothing special.
2. In the dashboard, selected the Widget category of Content Blocks -> *New Dynamic Content and added it to the dashboard.
3. Once I click on the Create a content block link, I filled out the form and added my code.
4. Back on the dashboard, I entered a search term that I know exists because I can see it in the demand list - but it doesn't do anything. I have verified the report is following the interactive filter.
Does anyone know what I'm missing?
My Dynamic Content block is called Demand Short Description and here is the code:
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-23-2024 06:54 AM - edited 02-23-2024 06:57 AM
Simply add a Space after LIKE for the filter message.
filter_message.filter = "sys_class_name=dmn_demand^short_descriptionLIKE " + searchTerm;