[SOLVED] Query $createdAt

DocumentList response = await databases!.listDocuments( databaseId: "*********", collectionId: "********", queries: [ Query.equal("user_phone_no", phoneNo), Query.orderDesc('$createdAt'), ], ); $createdAt show error, how can I query this, any help

TL;DR

Solution: The issue is with the syntax of the query for the `$createdAt` field. To fix it, you need to escape the dollar sign before `$createdAt` by using `'\$createdAt'`. Additionally, make sure you have created an index for the `$createdAt` field. If you're still facing errors, provide screenshots and more information about the error message. Remember to format your queries as an array.

have you created an index?

yes, its format error, it show me red

No the problem is on Query.orderDesc('$createdAt') I tried Query.orderDesc('${createdAt}') flutter consider it as local variable but its from appwrite database ($id, $createdAt, $updatedAt) common fields

queries should be passed as an array

only flutter expert answer me pls queries: [ Query.equal("user_phone_no", phoneNo), Query.orderDesc('$createdAt'), ],

$createdAt shows red error, format error

what is the error you're getting. show screenshots

also, show your indexes