Hello,
I try to run Supabase Database | Select action in workflow and generally is ok. But how to filter by empty column like it is in collection?
Here is Database | Select in workflow and i cant find filter if its empty. I tried to to change different conditions and for value to write manually, empty, EMPTY, “empty“, “EMPTY“, null, NULL, “null“, “NULL”, just ““, leave nothing… but always return error.
From other side, in Collection have filtering by “Is empty“. I need to change filter dynamically so it become problem. Also Database | Select action dont have Sort By which exist in collections.
Why dont have option me to write some SELECT query in Database | Select action?
Hope somebody will help. Thank you in advance.