Hello,
I am trying to filter a table to show only records without a value in a field called “grouping.” My table filter is:
The “filter_grouping” variable is populated via single-select dropdown which has an aggregation as a datasource:
When I select the blank option in the dropdown, records with non-blank values in “grouping” are returned:
However, I only want records without values in this field to be returned. Is it possible?
I am guessing that the the third value of your dropdown list to enter the filter_grouping variable is null.
If you change null to empty string, you get the expected result.
At least that was how my test App behave.
app.json (7.9 KB)
(Although I don’t understand why equal to null filter is showing every record…)
I guess what you are seeing is the same with Case 1 in Aggregation sum give 0 when empty
Hi ta-aoki, thank you for taking the time to investigate and reply! I will try this out and see how it goes.
