NOT MUST queries

Elastic Stack Elasticsearch
1

Hi... I am new in this amazing toll... and I have the following problem:

I have a set of 1,000,000 customers and they are set as parents of the event "purchase", which contains a list of products customers bought with a property "category".

I want to know which customers have NEVER bought a product with category = "shoes". If I use a MUST NOT in the query I will get all customer that have at least one "purchase" without a product with category = "shoes"... which is not the same thing a "NEVE HAS BOUGHT"

Is there a query that helps me get this info? Like (MUST NEVER HAVE... lol)

Thanks

2

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.