Interactive Filter / Multiple Tables

bekfro · ‎08-31-2023

We have an interactive filter created with multiple tables referenced.

This is working for all tables except the sc_task table. That seems to be affected by all fields for the interactive filter:
I've tried to toggle on an off the "Apply to all tables in hierarchy" with no success.
Any ideas on how to fix this?

This is my filter conditions if I do use the filter for the catalog task table:

Which looks like it's using all the reference field mappings.

bekfro · ‎09-07-2023

I did find this in KB Reference type Interactive filter not working on the dashboard , showing "No Data to Display" - Supp...

So I had to update one of the report to not use the task table (used task_sla ) to keep the reference field in the right mappings. Then removed the task table from the filter and we are all set.

Thanks for walking through this with me!

View solution in original post

AndersBGS · ‎08-31-2023

HI @bekfro ,

I do not understand your comment "That seems to be affected by all fields for the interactive filter" what does this mean? What is the issue?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

Rebecca Froehli · ‎09-04-2023

@AndersBGS

If you look at the second image in my post you can see the catalog task table is getting filtered by all tables referenced in the interactive filter mappings instead of just what is mapped for sc_task.
I have not seen this before…

AndersBGS · ‎09-07-2023

Hi @Rebecca Froehli ,

Ok, I understand - how does the filter look if you try to utilize it from the incident table?

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

bekfro · ‎09-07-2023

@AndersBGS
I'm glad you asked, I thought Incident was working as it should, but the task table has taken over all the filtering.

The Incident table has filter conditions doubled.

I have toggled back and forth the apply to all tables in the hierarchy & apply to both database view and tables with no change in the results.

It must have something to do with the extended tables. I wonder if there is a system property I need to adjust.
I used these types of interactive filters at my previous job, but never ran into this problem.