Added Filtering by _createdAt, and _updatedAt to CMS API Filter Query - #138
Added Filtering by _createdAt, and _updatedAt to CMS API Filter Query#138hyunnbunt wants to merge 12 commits into
Conversation
|
The latest updates on your projects. Learn more about Vercel for Git ↗︎
1 Skipped Deployment
|
|
@hyunnbunt is attempting to deploy a commit to the Plasmic Team on Vercel. A member of the Team first needs to authorize it. |
hyunnbunt
changed the title
|
Thank you for your submission, we really appreciate it! ❤️ Like many open-source projects, we ask that you sign our Individual Contributor License Agreement before we can accept your contribution. If you are contributing on behalf of a company, please contact us at [email protected] to sign a Corporate Contributor License Agreement. You can sign the individual CLA by posting a comment with the below text. I have read, agree to, and hereby sign Plasmic's Individual Contributor License Agreement You can retrigger this bot by commenting recheck in this Pull Request. Posted by the CLA Assistant Lite bot. |
…ating correct sql
I rebased it and add sql tests for createdAt, updatedAt fields! |
Merge - #137 - #138 - minor edits to tests --------- Co-authored-by: hyunnbunt <[email protected]> GitOrigin-RevId: 49e8e13d04c02e21a4a45a459cdca9d814dea54a
|
Merged in 2e41cb9 |
2 participants
Implements filtering for rows based on the _id, _createdAt, and _updatedAt columns in the query. Users can now include these fields within the where parameter to filter results. For _createdAt and _updatedAt, filtering by a specific date and time (ISO 8601 format: YYYY-MM-DDTHH:mm:ssZ) is supported.
{"where":{"_createdAt": "2025-04-04T06:52:32.500Z"}},
{"where": {"$and": [{"_createdAt": {"$ge": "2025-04-04T00:00:00.000Z"}}, {"_createdAt":{"$lt":"2025-04-15T22:00:00.000Z"}}]}}