Problem: One table filter doesn't work

Hey there,

I have another problem with an app. As you can see in the video down below, there is a table on my app with four different filter. Every filter works as I want, except of the fourth one. If I fill in some data into the filter, nothing is found in the table. That is correct, because currently no row has a data in the column “Ausdrehring”. But if I clear the filter “Ausdrehring”, the table doesn’t load back its data… Why? I have copied the filter “Ausdrehring” from one of the other three filters above and they work as they should, they load back all the table data if nothing is filled in.
So, what is the problem here?

1 Like

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

I don’t have the “clear X” feature yet but I would call that a bug too. We added small “X” buttons for each filter field on our UI to restore the value to null so that we can get results when the filter is null.

1 Like

This feature is only available on single line text inputs and has to be activated in the right hand panel:

Ah thanks, good to know. I have a single line text input here und I activated the button, but where can I find it? I don’t see this clear button on my app :smiley:

Only if you enter some value in the input.

You can test it in the App builder, when selecting the widget, hitting TAB and starting to type. But the cancel logic will only work, when the app is running

1 Like

Okay, thanks. But if I press the “X” in the last filter, it also did not reset my table data. With an extra button at the filter, this works.

Thats what I said:

As mentioned… I find this is a bug…

1 Like