DatabasesWeb

Query Appwrite

Dec 12, 2024, 15:00

View on Discord

Votes

Replies

Participants

Unknown

Messages

MorelOriginal post

Rank 1: Thread

Dec 12, 2024, 14:33

Hello, I have a question regarding Queries in Appwrite. If I have a string "YYYY-MM", how can I query the $createdAt column to match this filter?

Summary

The developer is querying the $createdAt column using a string in the format "YYYY-MM". The solution is to create variables for the start and end of the month using the provided date string. Then, include a query to filter records between these dates using `sdk.Query.between('$createdAt', startOfMonth, endOfMonthISO)`.

Morel

Rank 1: Thread

Dec 12, 2024, 14:35

const date_time = "2024-11";
const batchs = await databases.listDocuments(
process.env.APPWRITE_DATABASE_ID,
process.env.APPWRITE_COLLECTION_ID,
[
?
]
);

Morel

Rank 1: Thread

Dec 12, 2024, 14:41

[SOLVED]

   const startOfMonth = "${date_time}-01T00:00:00.000Z";
    const endOfMonth = new Date("${date_time}-01T00:00:00.000Z");
    endOfMonth.setMonth(endOfMonth.getMonth() + 1);
    endOfMonth.setDate(0);
    const endOfMonthISO = endOfMonth.toISOString();
    query.push(sdk.Query.between('$createdAt', startOfMonth, endOfMonthISO));

Query Appwrite

Need support?_