yeah but in the case of $ the first case would match everything. my goal is that it’s matched as much as it could and its that’s all the fields that row has it would still be a match.
lets say i’m searching for
“filter”: {“genre”: {“$in”: [“action”, “drama”]}}
with data like
vector1: { “genre”: [“comedy”, “action”] }
vector2: { “genre”: [“comedy”, “action”, “documentary”] }
vector3: { “genre”: [“action”] }
this will produce a match on all 3 vectors but I only want this query to match on vector3. Because the other vectors include genres not included in the search query. However, vector3 despite not having drama matched all the searchquery with its fields.
Lemme know if this makes sense? Its kinda of a unique search
Unfortunately metadata filtering doesn’ts support wildcards, so you’ll need to add all of the other genres you’re tracking manually to the “$nin” list. But this should do what you’re looking for.
Hi Cory, any ideas of when wildcard matching will be available? starting to see a potential problem in the future where genre doesn’t have a capped unique limit. Don’t want to send a list of $nin of unknown size