How to write a conditional query with Elasticsearch?

Question

I have a simple JSON query for Elasticsearch that looks like this:

"query": {
  "bool": {
    "must": { "match": { "id": "1" }} ,
    "must": { "match": { "tags.name": "a1"}}
   }
}

How can I execute the second 'must' criteria ONLY if the value ('a1' in this case) is not empty?

You better handle it at the time of query construction through the client. — Prabin Meitei
– Prabin Meitei, Commented Apr 25, 2015 at 16:28

Vineeth Mohan · Accepted Answer · 2015-04-26 04:41:38Z

11

You can achieve it using the following -

{
  "query": {
    "bool": {
      "must": [
        {
          "match": {
            "id": "1"
          }
        },
        {
          "bool": {
            "should": [
              {
                "missing": {
                  "field": "tags.name"
                }
              },
              {
                "match": {
                  "tags.name": "a1"
                }
              }
            ]
          }
        }
      ]
    }
  }
}

answered Apr 26, 2015 at 4:41

Vineeth Mohan

19.4k9 gold badges70 silver badges81 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Shivaank Tripathi · Accepted Answer · 2018-07-22 21:03:42Z

0

I don't think "missing" can be used in the latest versions of elasticsearch. But one can use Conditional Clauses instead. https://www.elastic.co/guide/en/elasticsearch/reference/6.3/search-template.html#_conditional_clauses

answered Jul 22, 2018 at 21:03

Shivaank Tripathi

113 bronze badges

Collectives™ on Stack Overflow

How to write a conditional query with Elasticsearch?

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related