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?