Filter not working with the value TRUE

I have a table with a column called “Filter” where the value is either TRUE or FALSE (resulting from a boolean formula). When I try to use the filter feature on this column, it is not showing the rows with the value TRUE. The screenshot shows how I have the filter set up.

image

I can of course turn the Filter column into 1s and 0s and set the filter to a value of 1, but I just wanted to report that the Filter is not working when you enter TRUE as the value.

Thanks for reporting this issue.
We are tracking this internally as #004668

As a work around, please try out “true” instead of “TRUE” in filter criteria.
TRUE is a formatted value we show in cell-renderers and will resolve it shortly

2 Likes

Ah yes, lowercase “true” works. Thanks!

2 Likes

By the way, this also applies to conditional formatting. Lowercase “false” works but uppercase does not.

2 Likes

They share the same component. We will ensure the fix in both places. Thanks.

2 Likes