Select fields to query
Hello 👋
I’m having an issue here I store large text content inside convex along with some metadata.
My issue is that sometimes I only need the metadata and the query fails because of the huge size of the texts.
How can I only query some fields?
4 Replies
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!
Sounds like you should consider splitting this up into two tables. you could have one
metadata table that just holds the metadataThat's what I considered doing but I'm quite baffled that there is no smarter way to do this...
As of now you can only query a full document from any table (i.e. fetch all columns, you can't do
select columnA...), and as far as I know, the team doesnt intend on changing this soon, although the question comes up not infrequently, so who knows!