Tom Redman•10h ago

Can you query a table with an index using just _creationTime?

Silly question: Can you query a table using the built-in index on "_creationTime"? E.g. ctx.db.query("users").withIndex("_creationTime", (q) => q.gte(1762870387000)).collect();

3 Replies

Convex Bot•10h ago

Thanks for posting in <#1088161997662724167>. Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets. - Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.) - Use search.convex.dev to search Docs, Stack, and Discord all at once. - Additionally, you can post your questions in the Convex Community's <#1228095053885476985> channel to receive a response from AI. - Avoid tagging staff unless specifically instructed. Thank you!

jamwt•7h ago

Yes! This is the default index, actually. That’s on every table.

Tom RedmanOP•6h ago

@jamwt AH I found it! Was looking for the index name. I was trying dumb things like "by__creationTime" and other such nonsense.

await ctx.db.query("emailEvents").withIndex("by_creation_time", (q) =>
    q.lte("_creationTime", 0)
).collect();

await ctx.db.query("emailEvents").withIndex("by_creation_time", (q) =>
    q.lte("_creationTime", 0)
).collect();

Can you query a table with an index using just _creationTime?

Did you find this page helpful?