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 Pulumi LSP

Install Pulumi Emacs Mode The source code is on https://github.com/pulumi/pulumi-lsp. At the very bottom of the page are the instructions on how to install. You Need to have make installed. $ make install emacs-client mkdir -p ./bin go build -ldflags "-X github.com/pulumi/pulumi-lsp/sdk/version.Version=v0.2.3-6-gec49054" -o ./bin -p 10 ./cmd/... go: downloading github.com/pulumi/pulumi/sdk/v3 v3.53.1 ... ... ... go install -ldflags "-X github.com/pulumi/pulumi-lsp/sdk/version.Version=v0.2.3-6-gec49054" ./cmd/... mkdir -p editors/emacs/bin cd editors/emacs && emacs -Q --batch --eval "(progn (setq package-user-dir \"$(pwd)/bin\" \ package-archives '((\"melpa\" . \"https://melpa.org/packages/\") \

emacs29 intelephense

Emacs 29 and PHP Intelephense I use to use Emacs and PHP Intelephense for PHP development. I recently upgraded to Emacs 29 and PHP Intelephense stopped working. I found a solution on Reddit Based on that, I rewrote my .emacs file to use eglot instead of lsp-mode, and this is the result. (use-package eglot :ensure t) (add-hook 'php-mode-hook 'eglot-ensure) (use-package php-mode :ensure t :mode ("\\.php\\'" . php-mode)) (add-to-list 'auto-mode-alist '("\\.php$" . php-mode)) (provide 'lang-php) (use-package company :ensure t :config (setq company-idle-delay 0.3) (global-company-mode 1) (global-set-key (kbd "M- ") 'company-complete)) (require 'eglot) (add-to-list 'eglot-server-programs '((php-mode :language-id "php") . ("intelephense" "--stdio" :initializationOptions (:licenseKey "98989898989898989898"