sdk: dart version: 19.2.1
TypeScript
.subtract(const Duration(days: 1))
.toIso8601String();
await database.deleteRows(
databaseId: Platform.environment['DATABASE_ID']!,
tableId: Platform.environment['TABLE_ID']!,
queries: [Query.createdBefore(timestamp)],
);```
This code fails with: AppwriteException: general_query_invalid, Invalid query method: createdBefore (400)
TL;DR
Issue with using 'createdBefore' query on bulk delete; it doesn't work as expected. Solution: Use 'lessThanEqual' query with '$createdAt' instead. 29 Oct, 2025, 11:13
Are you using Cloud or self-hosted? If self-hosted, which version?
29 Oct, 2025, 11:28
This also doesn’t work for me on Cloud. But using lessThanEqual query with $createdAt does work.
29 Oct, 2025, 17:12
self-hosted version 1.8.0
Recommended threads
- MariaDB refuses to connect to appwrite
Earlier, I tried updating my Appwrite version from 18.1.x to the latest release because my Flutter package required it to function properly. I used the official...
- executeFunction intermittently throws Fo...
Environment: Flutter app using the Appwrite Flutter SDK, calling executeFunction for [describe endpoint, e.g. live-stream-related function]. *Description*: Int...
- Console display all Databases as TablesD...
While looking at an issue with <@1231860789355347971> we saw that the console was displaying ALL databases as `TablesDB` even if the real type in the API is `le...