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
- MongoDb Database Breaks integer[] & bigi...
I've got a table with the below column created. When I try to insert the value `[-3408048000]` into it, the dart sdk cloud function call is successful (no error...
- Delete on cascade from Cloud Function
I'm writing a Python function that deletes a user's main row from a table in my database. This row has relationships with other tables that use cascade deletion...
- 1.9.6 Console handles all array columns ...
When creating or updating a row in the appwrite 1.9.6 web console, the form treats all list columns as a type string. Even if the column is a list of booleans, ...