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

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&

Emacs TypeScript Development

Emacs Configuration for Typescript In order to comfortably develop on Node, React or Angular projects with Emacs, TIDE is a good solution. We have TypeScript code highlight (that is the minimum!) and code completion based on the codebase (not only on locally defined and builtins) In order to achieve that: Install Emacs (24+) Install Node Install Typescript (which will provide "tsserver") Install TIDE and some usefull dependencies Configure Emacs to use all those Node is then installed in " /home/mihamina/Apps/node-v12.18.0-linux-x64/bin ": you should add it to your PATH. Installing Typescript is done with: npm install --save typescript @types/browserify After that, "tsserver" will be in " /home/mihamina/node_modules/.bin " Then comes the installation of TIDE: With the Emacs package manager, M-x package-install , install "tide". Do the same for "web-mode", "flycheck", "company" "js2-mode" and "

dockerfile multiline to file

Outputing a multiline string from Dockerfile I motsly use a Dockerfile by sourcing from a base ditribution: CentOS or Debian. But I also have a local mirror and would like to use it for packages installation. Espacially on CentOS it is about many lines to write to the /etc/yum.repos.d/CentOS-Base.repo file. Easiest way: one RUN per line The first method that comes in mind is to issue one RUN per line to write. Here you are: RUN echo "[base] " > /etc/yum.repos.d/CentOS-Base.repo RUN echo "name=CentOS-$releasever - Base " >> /etc/yum.repos.d/CentOS-Base.repo RUN echo "baseurl=ftp://packages-infra.mg.rktmb.org/pub/centos/7/base-reposync-7 " >> /etc/yum.repos.d/CentOS-Base.repo RUN echo "gpgcheck=0 &quo