How to create a bool filter on multiple fields in Elasticsearch?

Question

I have the following query in Elasticsearch:

{
  "script_fields": {
    "travel_time": {
      "script": {
        "inline": "doc['DateTo'].value - doc['DateFrom'].value"
      }
    }
  }, 
  "stored_fields": [
    "_source"
    ], 
  "query": {
    "bool": { 
      "filter": {
        "exists": {
          "field": "DateTo"
        }
      }
    }
  }
}

How can I add DateFrom into exists filter?

which version of elasticsearch do you use?

Tobias Gassmann
– Tobias Gassmann

2017-10-19 14:53:19 +00:00
Commented Oct 19, 2017 at 14:53 — Tobias Gassmann
– Tobias Gassmann, Commented Oct 19, 2017 at 14:53
@TobiasGassmann: 5.5

Dinosaurius
– Dinosaurius

2017-10-19 14:53:50 +00:00
Commented Oct 19, 2017 at 14:53 — Dinosaurius
– Dinosaurius, Commented Oct 19, 2017 at 14:53

Val · Accepted Answer · 2017-10-19 15:02:15Z

1

You can add multiple exists criteria:

  "query": {
    "bool": { 
      "filter": [
       {
         "exists": {
           "field": "DateFrom"
         }
       },
       {
         "exists": {
           "field": "DateTo"
         }
       },
       {
         "script": {
           "script": {
             "inline": "doc['DateTo'].value - doc['DateFrom'].value > 0"
           }
         }
       }
      ]
    }
  }

edited Oct 19, 2017 at 15:02

answered Oct 19, 2017 at 14:56

Val

218k14 gold badges377 silver badges384 bronze badges

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

1 Comment

Dinosaurius Over a year ago

Ah, ok. Can I also add the filter that "doc['DateTo'].value - doc['DateFrom'].value" should be a positive numeric value?

Collectives™ on Stack Overflow

How to create a bool filter on multiple fields in Elasticsearch?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related