Hello. I need a light to see how we can do this using algolia.
Our system has categories and subcategories.
One product can have 1 category, and up to 3 subcategories.
A requirement was made per product, per category, and/or subcategory to set a score with the following behavior:
- If I search by a subcategory, I should pin to the top the products that contain that score (ordered by it).
- If I search by 2 or more subcategories, I should pin to the top the products that have that score.
Now the border case:
- If a product has a score in one subcategory, but it doesn’t have in another (remember I have up to 3 sub cats), and I search by that other, I need to NOT pin that product to the top.
Is there a configuration that could help me with this?, technically I would need something that behaves as an “AND” instead of OR?
Thanks in advance!