Back
Query null OR greaterThanEqual than
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.
TL;DR
The user is having an issue with implementing a query in their Dart app using the appwrite package version 7.1.0. They want to query a datetime attribute that can be null and return all projects after a given date or isNull. However, they are unable to find a way to build this query since the queries are connected using AND and not OR. A solution suggested by another user is to use two separate queries for now. There is also a related issue linked for reference.
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 👍
