馃憻 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?
馃彚 Have you read the Code of Conduct?
馃憻 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 anafterCursor(), it doesn't don't take into account documents with anullattribute.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
nullvalues.馃憥 Actual Behavior
afterCursor() doesn't retrieve documents with a
nullvalue.馃幉 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?
馃彚 Have you read the Code of Conduct?