Non empty values from Query all Records?

Georges Duverger

I have a Query all Records function on a `users` table. In that `users` table, there is an optional `token` column of type `text`. I would like to return all the users who *have* a token. In other words, ignore users where `token` is null or empty. It seems pretty straightforward but, for some reason, I haven't been able to figure it out. Attached is my naïve attempt. Any pointers?
[xb4a-a0yo-esyv.n7.xano.io_admin_workspace_7_api_19_query_122 (1).png]

Michael Udinski

You actually don't need to put in those quotation marks at all, so it would look something more like this:

[Screenshot_2021-08-24_21-29-42.png]
For null, there is a constant null that you can access with the selector or by typing it in

Georges Duverger

Excellent! It worked. So simple. Thank you, , for the prompt response. 🙏