Interactive filter not working

[osvaldo2]

I created a (true/false) column named u_requires_clearance in the core_company table .

I then created an interactive filter "Require Clearance"

I added the filter to the dashboard but it is not filtering the list of tickets based on this filter? It is support to filter the list based based on what companies have the requires clearance table has true or false. The filter is already set as "act as interactive filter" and the list on the report is already set to "follow interactive filter". I the list of tickets are getting derived from the task table in which core_company is a column in that table. Any ideas why it is not filtering?

[Adam Stout]

Boolean and Choice lists have to be configured on the table they are operating on (this is different than reference and dates which have mappings).

I would expect this to work on the core_company table but not on tables that reference core_company.  You need to set up a different filter if you want to see that.  For example, on Incident, you would have incident.caller.comapany.u_require_clearance.

[osvaldo2]

The only reason I am doing the report list on the task table is because the task table goes into changes, incidents, and requests so i have the list of all active tickets instead of trying to report by each table. Is there another way to achieve the filtering I am trying to accomplish?