Elasticsearch JAVA API for script tag

Question

I have to query elasticsearch for sum of two fields in a doc, that fall in a particular range.

I'm trying to create a Java API for the below elastic search query, but not able to make out how to include script tags and select doc elements i.e doc['maintenanceCost']. Any help would be appreciated.

{
   "query": {
       "bool" : {
           "filter" : {
               "script" : {
                   "script" : "doc['price'].value + doc['maintenanceCost'].value  > 1000 && doc['price'].value + doc['maintenanceCost'].value  < 10000"     
           }
           }
       }
   }
}

I basically need docs in which sum of price andenter code here maintenance cost fall between 1000 to 10000

I have tried out few queries like ScriptBuilders, but none of them worked

Daantie · Accepted Answer · 2019-08-23 12:38:42Z

1

You can use QueryBuilders.scriptQuery() with the Script object for this. In your case it would be something like this:

QueryBuilders.scriptQuery(
        new Script("doc['price'].value + doc['maintenanceCost'].value  > 1000 && doc['price'].value + doc['maintenanceCost'].value  < 10000")                  
    );

More detailed information about this method can be found here.

answered Aug 23, 2019 at 12:38

Daantie

1,01111 silver badges14 bronze badges

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

Collectives™ on Stack Overflow

Elasticsearch JAVA API for script tag

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related