elasticsearch dynamic query - Add another field to each document returned

elasticsearch elasticsearch-jdbc-river elasticsearch-plugin pyelasticsearch spring-data-elasticsearch

I did this using script fields. Refer:

sample query:

query: {...},script_fields: {  inventory: {     script: "doc['car'].value + doc['bike'].value"  }}

This would result in a separate fields column with each hit as:

fields: {    inventory: [450]}

But, since I also wanted this to be sorted, I ended up using the sort:

query: {...},sort: {    _script: {        script: "doc['car'].value + doc['bike'].value",        type: "number",        order: "desc"    }}

which returned me a sort field with each hit, such as:

sort: [450]

CodeHunter