Interactive Filter / Multiple Tables

[bekfro]

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. 

[AndersBGS]

Hi @bekfro ,

In general, now I don't know all the places you have utilized this interactive filter, but if you "just" remove the task table from the interactive filter references, I think it will work. 

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

Best regards

Anders

[bekfro · Accepted solution]

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!

[AndersBGS]

Hi @bekfro ,

great to hear that it have all worked out. Please remember to accept solution to the question, so all other community members can see it is as resolved.

If my answer has helped with your question, please mark my answer as accepted solution.

Best regards

Anders