How do I filter on an Boolean Column in an Information Link

[Ryan James 3]

Is it possible to create a filter on a Boolean column in an information Link I'm trying to do it with two columns but I keep getting and error.

My attempt:

%1 != 'Location' AND %2 IS True

[Shashank Gurnalkar]

Can you try to use '=' instead of 'IS' as it does not seem to be a valid operator

https://docs.tibco.com/pub/sfire-analyst/10.8.0/doc/html/en-US/TIB_sfire-analyst_UsersGuide/id/id_relational_operators.htm

Use the value Truein the same format as present in your database (True, TRUE, true). If this still fails, try using just 1 as:

%1 != 'Location' AND %2 = 1Let me know if this helps.