elasticsearch

elasticsearch filter by length of a string field


i am trying to get records the has in 'title' more then X characters.

NOTE: not all records contains title field.

i have tried:

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

as a result, i get this error:

GroovyScriptExecutionException[NullPointerException[Cannot invoke method length() on null object

how can i solve it?


Solution

  • You need to take into account that some documents might have a null title field. So you can use the groovy null-safe operator. Also make sure to use the POST method instead:

    POST books/_search
    {
        "filter" : {
              "script" : {
                  "script" : "_source.title?.size() > 10"
              }
          }
    }