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?
Hi @JoelBGT
here comes the reason and the workaround
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:
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.
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
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