Skip to main content

elasticsearch script field

I often need to compute some fields of a Elasticsearch record and make it part of the result.

For example, I have this document:

{
  "fields": {
    "connected": [true],
    "incall": [false],
    "timestamp": ["2021-09-02T10:35:06.000Z"]
  }
}

And I want to have a field named "lack_of_optimization" which is 1 when "connected" is "true" AND "incall" is "false"
See this from the point of view of a callcenter manager: when the callcenter agent is "connected" but not in call, it can be rated as a lack of optimization

In other words:

if( connected && incall)
  lack_of_optimization = 0
else
  lack_of_optimization = 1

To achieve this, we need to write a script that will compute the value of the fields "connected" and "incall" then return a 0 or a 1 depending on the result. HEre is the query: 

{
  "size": 750, 
  "sort":[
    {
      "timestamp":{
        "order":"desc",
        "unmapped_type":"boolean"
      }
    }
  ],
  "fields": [
    {"field": "incall"},
    {"field": "connected"}
  ],
  "script_fields":{
    "lack_of_optimization":{
      "script":{
        "source":"""
           if (doc['connected'].value == true && doc['incall'].value == true) 
           { 
             0; 
           } else { 
             1; 
           }
        """
      }
    }
  },
  "_source":false,
  "query":{
    "bool":{
      "must":[],
      "filter":[
        {"match_all":{}},
        {
          "range":{
            "timestamp":{
              "gte":"2021-08-15T00:30:00+0300",
              "lte":"2021-08-15T01:00:00+0300",
              "format":"strict_date_optional_time"
            }
          }
        },
        {"match_phrase":{"connected":true}}
      ],
      "should":[],
      "must_not":[]
    }
  }
}

The needed script is the value of the "source"

  "script_fields":{
    "animation_value":{
      "script":{
        "source":"""
           if (doc['connected'].value == true && doc['incall'].value == true) 
           { 
             0; 
           } else { 
             1; 
           }
        """
      }
    }

In the Elasticsearch documentation, it is refered as a "script field", written in the "Painless language"

The final document will then include the computed field:

    {
        "fields" : {
          "connected" : [
            true
          ],
          "incall" : [
            false
          ],
          "lack_of_optimization" : [
            1
          ]
        }
      }



Popular posts from this blog

Undefined global vim

Defining vim as global outside of Neovim When developing plugins for Neovim, particularly in Lua, developers often encounter the "Undefined global vim" warning. This warning can be a nuisance and disrupt the development workflow. However, there is a straightforward solution to this problem by configuring the Lua Language Server Protocol (LSP) to recognize 'vim' as a global variable. Getting "Undefined global vim" warning when developing Neovim plugin While developing Neovim plugins using Lua, the Lua language server might not recognize the 'vim' namespace by default. This leads to warnings about 'vim' being an undefined global variable. These warnings are not just annoying but can also clutter the development environment with unnecessary alerts, potentially hiding other important warnings or errors. Defining vim as global in Lua LSP configuration to get rid of the warning To resolve the "Undefined global vi...
Read more

wget maven ntlm proxy

How to make wget, curl and Maven download behind an NTLM Proxy Working on CentOS, behind an NTLM proxy: yum can deal without problem with a NTLM Proxy wget, curl and Maven cannot The solution is to use " cntlm ". " cntlm " is a NTLM client for proxies requiring NTLM authentication. How it works Install "cntlm" Configure "cntlm"  by giving it your credentials by giving it the NTLM Proxy Start "cntlm" deamon (it listens to "127.0.0.1:3128") Configure wget, curl and Maven to use "cntlm" instead of using directly the NTLM Proxy Note: You will have then a kind of 2 stages Proxy : cntlm + the NTLM proxy Configure CNTLM After installing cntlm, the configuration file is in "cntlm.conf". You must have your domain (in the Windows meaning), proxy login and  proxy password. Mine are respectively: rktmb.org, mihamina, 1234abcd (yes, just for the example) You must have you NTLM Proxy Hostnama or IP ...
Read more

npm run build base-href

Using NPM to specify base-href When building an Angular application, people usually use "ng" and pass arguments to that invocation. Typically, when wanting to hard code "base-href" in "index.html", one will issue: ng build --base-href='https://ngx.rktmb.org/foo' I used to build my angular apps through Bamboo or Jenkins and they have a "npm" plugin. I got the habit to build the application with "npm run build" before deploying it. But the development team once asked me to set the "--base-href='https://ngx.rktmb.org/foo'" parameter. npm run build --base-href='https://ngx.rktmb.org/foo did not set the base href in indext.html After looking for a while, I found https://github.com/angular/angular-cli/issues/13560 where it says: You need to use −− to pass arguments to npm scripts. This did the job! The command to issue is then: npm run build -- --base-href='https://ngx.rktmb.org/foo...
Read more