Hi there everyone, i am querying a table for data and i want to only collect documents created in the last 2 hours. please how do go about it?
#how do i filter a query by documents created in the last 2 hours?
latent jay
carmine swan
Compare _creationTime to current time:
const isRecent = Date.now() - new Date(_creationTime).getTime() <= 2 * 60 * 1000
oh duh you need to index
Some examples here: https://docs.convex.dev/database/indexes/#querying-documents-using-indexes
leaden forge
You can also do this using the built-in index:
const cutoff = Date.now() - 2 * 60 * 1000;
return await ctx.db
.query("messages")
.withIndex("by_creation_time", (q) => q.gt("_creationTime", cutoff))
.collect();
Ah so there is a built-in for that, I was wondering