🐛 Bug Report: Query order desc not include null values

[mr-saw]

👟 Reproduction steps

When I want to retrieve a list of documents with a Query.orderDesc() (having an Integer as an attribute type), which has a pagination with the use of an afterCursor(), it doesn't don't take into account documents with a null attribute.

Here is a more telling example :
id value
1 4
2 1
3 2
4 null
Query: order desc (value) - limit 100
1 3 2 4 (total: 4)
Query: order desc (value) - limit 2
1 3 (total: 4)
Query: order desc (value) - limit 2 - afterCursor(3) # expected
2 4 (total: 4)
Query: order desc (value) - limit 2 - afterCursor(3) # actual
2 (total: 4)

👍 Expected behavior

afterCursor() should retrieve any list with null values.

👎 Actual Behavior

afterCursor() doesn't retrieve documents with a null value.

🎲 Appwrite version

Version 1.4.x

💻 Operating system

Linux

🧱 Your Environment

No response

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[pankaj-2503]

Hey , i am understanding the issue how can i contribute to it if i have knowledge of some backend with frontend in mern stack

[abnegate]

Hey , i am understanding the issue how can i contribute to it if i have knowledge of some backend with frontend in mern stack

Hi @pankaj-2503, you are welcome to contribution a fix over in the database repository 😁 please check out contribution guide first.