Hi,
I am writing SQL queries and using a variable of type "field filters," which retrieves a nested value from an associated table. However, I don't see an option to filter by null values. Is there a way to filter by null values in this context?
If you filter by "empty" that should include null values but I am not sure I understand your problem fully ... Can you share some screenshots
Well let me try to explain it better, when I write SQL queries and use field filters to provide automatic filter, the drop-down that is added for filter fetches the values present in that column, to allow me to filter by. However, that only lists the actual values. Suppose there is a category foreign key on a product table, then the drop-down only shows the list of category names, however there's no way to filter for products where the category is empty/null.
Hey there!
This is currently not supported, here is a Github issue about it, with some possible workarounds that you can try out