Interactive Filter Not working

[drslry2]

Hi Gurus

I created an Interactive Filter (Choice List) off the cmdb_ci_appl table, its defined as follows:

However it's not working.....

Even though the 'Follow interactive filter' box is checked...

Let me know if you have an idea why its not working.

thanks,
Rob

[Mark Manders · Accepted solution]

Is that list indeed from the cmdb_ci_appl table? Business application come from the cmdb_ci_business_app table, so it could be referencing the wrong table.

[AndersBGS · Accepted solution]

Hi @drslry2 

as far as I can see, the interactive filter is created based on the applications table "cmdb_ci_appl", but the report refer to "cmdb_ci_business_app" Business application table. If this is correct, then this is the error. You need to have them on the same table. 

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

best regards

Anders

[drslry2]

Thanks for the great feedback!  I appreciate the quick and helpful responses!