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


(Justin Henderson) #1

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?


(system) #2

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