Possible to search field result where field does not exist in second query?

I'm trying to find a way to get Kibana to perform a query that excludes content from another query using specific field values. I know Elasticsearch is not a relational database but I would assume there is a way to easily perform a traditional SELECT name FROM products WHERE product_category_id NOT IN (SELECT product_category_id FROM product_category WHERE type = 'development').

Basically I have two data types where it would be extremely helpful to use the field value results of one query to filter out another query using Kibana. I know this can be done using an Elasticsearch client like Python but that is not user friendly for the end users.

Any thoughts?

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