Back
Facing issue with querying the database "$createdAt"
I'm using python appwrite function.
Error:
appwrite.exception.AppwriteException: Invalid query: Attribute not found in schema: _createdAt
Code:
TypeScript
results = Databases(client).list_documents('DATABASE', 'COLLECTION', [
Query.and_queries([
Query.equal('id', [user['$id']]),
Query.between('$createdAt', start_iso, end_iso)
])
])
For date conversion: datetime.now().isoformat()
TL;DR
Developers facing a database query issue with "$createdAt" attribute. In the Python SDK v5.0.3, they expect to use `and_queries` while the documentation only mentions `and`. The error indicates an "Attribute not found in schema: $createdAt."
Solution:
Ensure correct attribute naming convention, using `$createdAt` instead of `_createdAt`. 
Is it not just and? In the docs I'm not seeing and_queries
TypeScript
Query.and([
Query.equal('id', [user['$id']]),
Query.between("$createdAt", start_iso, end_iso)
])
I'm on v1.5.7 self-hosted appwrite version. Using python sdk v5.0.3
I just checked even in Python SDK v6.1.0; it's the same. However, the documentation has and only
I think the documentation is incorrect. In Python, or and and are built-in keywords.
Facing issue with querying the database "$createdAt"
