Hi! I am changing all my functions from V 1.4.13 to V 1.6.0, using python.
I got the following error when using limit:
Fetching documents with queries: ['equal("Status", "Existing")'] Total documents fetched: 0 No documents fetched. Error fetching documents: Invalid query: Syntax error.
def fetch_existing_documents(
databases: Databases, database_id: str, collection_id: str, context: Any
) -> List[Dict[str, Any]]:
documents: List[Dict[str, Any]] = []
last_document_id: str = None
while True:
queries = ['equal("Status", "Existing")']
if last_document_id:
queries.append(
f'cursorAfter("{last_document_id}")'
)
try:
context.log(f"Fetching documents with queries: {queries}")
response = databases.list_documents(
database_id=database_id,
collection_id=collection_id,
queries=queries, # Exclude limit for now
)
if isinstance(response, dict) and "documents" in response:
fetched_documents = response.get("documents", [])
if not fetched_documents:
context.log("No more documents to fetch.")
break
documents.extend(fetched_documents)
last_document_id = fetched_documents[-1]["$id"]
else:
context.error(f"Unexpected response: {response}")
break
except Exception as e:
context.error(f"Error fetching documents: {e}")
break
context.log(f"Total documents fetched: {len(documents)}")
return documents
On the photo, you can see the code snippet that works, but I get only 25 files. Do you have any idea how to solve this problem?
Recommended threads
- FCM Message error
When creating a message target via flutter sdk via ``` final target = await _account.createPushTarget( targetId: targetId, identifier: deviceTok...
- Bulk API limitations in self-hosted serv...
Environment: Appwrite Selfhost SDK: node-appwrite 28.0 Calling `upsertRows` (also applies to `createRows`/`updateRows`/`deleteRows`) with more than 100 rows fa...
- Self Hosted GitHub connection not adding...
After upgrading to 1.9.6 i noticed that i cannot search for new repositories when trying to add new functions. I removed the existing github connection via Set...