Sort by number + doing text search
I have a table of an item with a name, and a number field contaiing a score.
I want to create logic that will get me all the items matching a specific string for the name (no need vector search, just regular text search is good) sorted by the heights score descending.
Is this possible in convex? It is very basic functionlity but I couldn't find it in the docs.
3 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!
Right here: https://docs.convex.dev/search/text-search
Full Text Search | Convex Developer Hub
Run search queries over your Convex documents
So from what I understand it is not possible ?
How you will suggest to implement such a feature ?
In a SQL DB I would just do a like query and then order by