Problem: One table filter doesn't work

Hi @JoelBGT
here comes the reason and the workaround :slight_smile:

Reason:

  • The Filters on Text type columns find all, if the variables value is ‘null’
  • The Value of a text variable is not ‘null’ , but an empty string, if you “clear” the text input (using your keyboard).
    • Unfortunately that means, all rows with ‘null’ in this column, will be hidden (also on the other filters you have, if any of these values is ‘null’ it will disappear
  • Unfortunately the X Clear Input button also doesn’t clear the input to ‘null’ but empties the string.

Workaround:

  • Make a trigger Data manipulation> Clear > filterVariable to reset the filter.
    • You can provide it as a button or with a "If filterVariableis blank" check on theInput is exited` trigger…
      (See screenshot:

      )

hope that helps for now…

@Beth To me that behavior is a bug. It is likely that there is already a ticket.

1 Like