Combining must_not in ElasticSearch Query

kcm

I'm currently struggling with an ElastSearch query which currently looks the following:

...
"query": {
    "bool": {
        "must_not": [
            {
                "term": {
                    "bool-facet.criteria1": {
                        "value": false
                    }
                }
            },
            {
                "term": {
                    "bool-facet.criteria2": {
                        "value": false
                    }
                }
            }
        ]
    }
}
...

So now when either criteria1 OR criteria2 matches, the documents are ignored. How must the query look like so that only documents that match criteria1 AND criteria2 are ignored?

kcm

Since updating elasticsearch version was not possible I had to find another solution. This is what worked for me:

"query": {
    "bool": {
        "must_not" : [
            {
                "query": {
                    "bool": {
                        "must": [
                            {
                               "term": {
                                 "bool-facet.criteria1": false
                               }
                            },
                            {
                               "term": {
                                 "bool-facet.criteria2": false
                               }
                            }
                        ]
                    }
                }
            }
        ]
    }
}

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Term, nested documents and must_not query incompatible in ElasticSearch?

From Dev

Term, nested documents and must_not query incompatible in ElasticSearch?

From Dev

Elasticsearch must_not query doesn't match regex

From Dev

Elasticsearch array must and must_not

From Dev

Combining a query in Elasticsearch

From Java

Combining filter and must in elasticsearch

From Dev

ElasticSearch combining MultiMatch with Must

From Dev

elasticsearch must query combine OR?

From Dev

Elasticsearch - combining query_string and bool query in filter

From Dev

Combining query_string with bool filters in Elasticsearch 2.x

From Java

elasticsearch bool query combine must with OR

From Dev

Combining a IN and AND query

From Dev

Elasticsearch query results in 'No query registered for [must]'

From Dev

combining query for query optimisation

From Java

Elasticsearch difference between MUST and SHOULD bool query

From Dev

must match query not working as expected in Elasticsearch

From Dev

Min_score for a "must" in a bool query in Elasticsearch

From Dev

must match query not working as expected in Elasticsearch

From Dev

Min_score for a "must" in a bool query in Elasticsearch

From Dev

Combining query rules in Datomisca

From Dev

combining two tables query

From Dev

Combining data mysql query

From Dev

Combining query rules in Datomisca

From Dev

Parse Query - Combining OR statements with AND

From Dev

Combining Collections With Gremlin Query

From Dev

Combining 3 elasticsearch queries into one

From Dev

In elasticsearch, must match one of array, with optional extra query term

From Java

What is the difference between must and filter in Query DSL in elasticsearch?

From Dev

Using bool must match and match _all in one elasticsearch query

Related Related

  1. 1

    Term, nested documents and must_not query incompatible in ElasticSearch?

  2. 2

    Term, nested documents and must_not query incompatible in ElasticSearch?

  3. 3

    Elasticsearch must_not query doesn't match regex

  4. 4

    Elasticsearch array must and must_not

  5. 5

    Combining a query in Elasticsearch

  6. 6

    Combining filter and must in elasticsearch

  7. 7

    ElasticSearch combining MultiMatch with Must

  8. 8

    elasticsearch must query combine OR?

  9. 9

    Elasticsearch - combining query_string and bool query in filter

  10. 10

    Combining query_string with bool filters in Elasticsearch 2.x

  11. 11

    elasticsearch bool query combine must with OR

  12. 12

    Combining a IN and AND query

  13. 13

    Elasticsearch query results in 'No query registered for [must]'

  14. 14

    combining query for query optimisation

  15. 15

    Elasticsearch difference between MUST and SHOULD bool query

  16. 16

    must match query not working as expected in Elasticsearch

  17. 17

    Min_score for a "must" in a bool query in Elasticsearch

  18. 18

    must match query not working as expected in Elasticsearch

  19. 19

    Min_score for a "must" in a bool query in Elasticsearch

  20. 20

    Combining query rules in Datomisca

  21. 21

    combining two tables query

  22. 22

    Combining data mysql query

  23. 23

    Combining query rules in Datomisca

  24. 24

    Parse Query - Combining OR statements with AND

  25. 25

    Combining Collections With Gremlin Query

  26. 26

    Combining 3 elasticsearch queries into one

  27. 27

    In elasticsearch, must match one of array, with optional extra query term

  28. 28

    What is the difference between must and filter in Query DSL in elasticsearch?

  29. 29

    Using bool must match and match _all in one elasticsearch query

HotTag

Archive