Back
Database | can't use pagination together with attribute sorting
I get the error "Could not get documents from database" after some requests, when trying to query some documents with order and by cursor. Does anyone else experience this?
TL;DR
The developer is having trouble using pagination and attribute sorting together in the database. They are asking if the last document ID and page size are correct. They mention a "general_unknown" error, but don't provide further details.
What's the code or queries?
Looks like this
TypeScript
response = await database.listDocuments(
databaseId: Database.databaseId,
collectionId: Database.notesCollectionId,
queries: [
Query.limit(pageSize),
if (lastDocumentId != null) Query.cursorAfter(lastDocumentId!),
Query.orderDesc('tier'),
Query.orderAsc('index'),
],
);
I have two attributes I use to sort on. Tier is string (S,A,B,C,D), and index is a number
and can you share the full error?
Hi @Drake I was a long time away, I am sorry not having read and answered. It is a general_unknown error. This is all I can see:
Are you sure the last doc ID is correct and pagesize?
