elasticsearch script query with exists/missing filter

Question

i am trying to run a script with query filter. the script should return me all books with title gt 30:

GET books/_search
{
    "filter" : {       
          "script" : {
              "script" : "_source.title?.length() > 30"
          }
      }
}

this works.

but if i try to add some filter, like i want all the books that not has 'type' field :

GET book/_search
{
    "filter" : {        
          "script" : {
              "script" : "_source.title?.length() > 30"
          },
          "missing" : { "field" : "type" },
      }
}

then i get error:

nested: ElasticsearchParseException[Expected field name but got START_OBJECT \"exists\"]; }]

so i can i query for missing fields with script filter?

Val · Accepted Answer · 2016-01-27 13:27:50Z

2

You're on the right track, you simply need to combine both of your filters into a bool/must query.

POST book/_search
{
  "filter": {
    "bool": {
      "must": [
        {
          "script": {
            "script": "_source.title?.length() > 30"
          }
        },
        {
          "missing": {
            "field": "type"
          }
        }
      ]
    }
  }
}

answered Jan 27, 2016 at 13:27

Val

218k14 gold badges377 silver badges384 bronze badges

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

2 Comments

fafl Over a year ago

bool/must is just one example, there are more "Compound query clauses": elastic.co/guide/en/elasticsearch/reference/2.0/query-dsl.html

Val Over a year ago

Yes, eventually dis_max, indeed.

Collectives™ on Stack Overflow

elasticsearch script query with exists/missing filter

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related