I am trying to allow a user to decide whether they want to see table entries with any combination of “Active Record” status using a Boolean variable, but the filter functions don’t seem to allow this. Also they need to be able to filter by other content, and the goal would be to include only table rows that meet all criteria, which doesn’t seem to work either since an individual Boolean field has only three states, null/no/yes.
Looking for an efficient alternative approach to this…all I can think of is making it a text field and constraining the input to yes/no (and defaulting to null) and then using a multiselect filter instead, but that seems a little extra for something simple.
