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.

[Andrew_TND]

Hi @drslry2 

Are the values in the Environment a choice or reference field? If its a reference the interactive filter wont work when you select choice as it needs an interactive filter reference.

Please mark as helpful or if its resolved the issue, CORRECT!

[drslry2]

Its a Choice List definition...so I don't believe there's an interactive filter reference available.

[Andrew_TND]

@drslry2 In that case then it sounds like you may be pointing to the wrong table your interactive filter is looking at cmdb_ci_appl which is cmdb - applications but the out of box view for business applications is, cmdb_ci_business_app.

Do both tables match?

Please mark as helpful or if its resolved the issue, CORRECT!

[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.