I am trying to query a datetime attribute that can be null. For my search I want the query to return all projects after a given date (greaterThanEqual) or isNull. So far I cannot see how I can build a query like this, since the Queries are connected via AND and only in a Query itself things can be logically connected via OR.
You can use two separate queries for now. Also, linking a related issue: https://github.com/appwrite/appwrite/issues/2740
Alright thanks
I want to implement it in a function but it seems like there is no Query.isNull there... At least the compiler does not know it π
Can isNull only be used by the client?
I am using dart_appwrite: ^7.1.0
Yes thats the problem. I updated to 8.0.0 and it compiled correctly π
Recommended threads
- Functions in cloud console not works
please advise as all of my runing functions on Appwrite console was working before , but now it give this error [Invalid `headers` param: Value must be a valid...
- Cannot migrate from Supabase
Hi, I was trying to migrate from Supabase to the Appwrite database. My database had around 190K columns. I tried it twice. Both times, after 2 days, the proce...
- Production down - createExecution return...
Hey, Since 1.9.6 rollout in fra (~17:00 UTC, 14 Aug), POST /v1/functions/{functionId}/executions returns a 400 whenever the body includes an empty headers ob...