[Solved] Query for null value

Hi,

I have a document which have a key named "vendor_id" which is by default, null. Then it can be changed to specific User Id. What I'm trying to do is to get all documents which is either null and have a specific user id.

Use case, to get all documents which still doesnt have any vendor_id and also those that have his user id as the key in vendor_id.

My question is how to query a null value in a key, I tried something like

Query.equal("vendor_id", [``, ${user?.$id}]),

and it doesnt work. Thanks in advance.

TL;DR

The user is asking how to query for documents that have a null value or a specific user id in the "vendor_id" key. They tried using Query.equal("vendor_id", [``, `${user?.$id}`]) but it didn't work. The solution is to use the isNull query, which can be found at <https://appwrite.io/docs/products/databases/queries>. The thread also includes a link to a GitHub issue for further discussion and a suggestion to like the issue.

Use the isNull query: https://appwrite.io/docs/products/databases/queries

Hi Steven, if I use

Query.isNull("vendor_id"), it will only get the document if only the key null, so if I also want to get get documents that also have vendor_id as my user.$id, I would have to create another function that's something like Query.equal("vendor_id", [user.$id]) that will pull another batch of documents instead.

What I was hoping to achieve is to use something like Query.equal("vendor_id", [NULL, user.&id]) or Query.between("vendor_id", NULL, user.$id) (If I read the Query.between purpose correctly) that will pull both documents that have NULL vendor_id and my user.$id.