Query by array
How can I query and fetch all users given an array of
walletAddresses?
I have users table and each user has an optional walletAddress field.
I need to fetch all users (at once) given the walletAddresses array3 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!
I think u can add an index with walletAddress on the user table then loop over the walletAddresses array then fetch each user by index. If wallet address is unique in the table u can use the .unique() method as well.
Supporting doc: https://docs.convex.dev/database/reading-data/#join