Hi @forest condor. I'm kapa.ai, your friendly support bot. I will try to answer your question by searching through the knowledge base. :wave:
#Getting only some fields from query
smoky kestrelBOT
In Convex, queries always return entire documents, but you can map over the results to select only the fields you need. Here's how you can query documents by userId and return only the name and _creationTime fields:
export const getUserData = query({
handler: async (ctx) => {
const documents = await ctx.db
.query("yourTableName")
.withIndex("by_userId", (q) => q.eq("userId", ctx.auth.userId))
.collect();
return documents.map((doc) => ({
name: doc.name,
_creationTime: doc._creationTime
}));
}
});
This approach first retrieves the full documents using the index, then maps over the results to return only the fields you need. While it might seem inefficient to retrieve all fields when you only need a few, Convex is designed to be very fast by default Stack.
If you're using pagination, you can apply the mapping to the paginated results:
export const getUserDataPaginated = query({
args: { paginationOpts: v.any() },
handler: async (ctx, args) => {
const results = await ctx.db
.query("yourTableName")
.withIndex("by_userId", (q) => q.eq("userId", ctx.auth.userId))
.paginate(args.paginationOpts);
return {
...results,
page: results.page.map((doc) => ({
name: doc.name,
_creationTime: doc._creationTime
}))
};
}
});