filter in or contains

How do I filter to find where values contain a substring?

4 Replies

Oh .search? Ok I need to define a search index and use withSearxhIndex

https://docs.convex.dev/text-search is the solution if you're ok with matching on exact words. https://docs.convex.dev/vector-search can enable semantic search. We don't have a full substring/prefix search yet, that would work on parts of words.

Run search queries over your Convex documents

Run vector search queries on embeddings

SJ•15mo ago

if a field is of data type array how to find a specific record based on that field containing a value? like includes method on an array

ian•15mo ago

not currently possible. you can make a "join table" instead though - search for that and there should be some good threads