Cannot use createdBefore query on bulk delete - Threads - Appwrite

Skip to content

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.

Are you using Cloud or self-hosted? If self-hosted, which version?

This also doesn’t work for me on Cloud. But using lessThanEqual query with $createdAt does work.

Cool thanks, should definitely be working on Cloud, will check

1

self-hosted version 1.8.0

Reply

Reply to this thread by joining our Discord

Reply on Discord

Need support?

Join our Discord

Get community support by joining our Discord server.

Get premium support

Join Appwrite Pro and get email support from our team.