# Boost based on value of sum two fields

**URL:** <https://discuss.elastic.co/t/boost-based-on-value-of-sum-two-fields/314567>\
**Category:** Elasticsearch\
**Tags:** runtime-fields\
**Created:** [September 16, 2022, 10:08am UTC](https://discuss.elastic.co/t/boost-based-on-value-of-sum-two-fields/314567 "2022-09-16T10:08:20Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ismet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ismet/32/103499_2.png) [@Ismet](https://discuss.elastic.co/u/Ismet)\
**Post date:** [September 16, 2022, 10:08am UTC](https://discuss.elastic.co/t/boost-based-on-value-of-sum-two-fields/314567/1 "2022-09-16T10:08:20Z")

</div>

Hi, I have two inventory fields:

- inventory.warehouse1.availableInventory: 10
- inventory.warehouse2.availableInventory: 20

I need to make a query with sum of these two fields and make a boost if total \> 0.

I try to make runtime total field but get an error.

```auto
PUT product/_mapping
{
 "runtime": {
 "total": {
  "type": "long",
  "script": {
    "source": "emit(doc['inventory.warehouse1.availableInventory'].value + 
     doc['inventory.warehouse2.availableInventory'].value)"
   }
  }
 }
}

Error: 

 "reason": "Root mapping definition has unsupported parameters: [runtime : 
{total={type=long, script=. 
  {source=emit(doc['inventory.warehouse1.availableInventory'].value + 
   doc['inventory.warehouse2.availableInventory'].value)}}}]"

```

How to make sum of two fields and make condition \> 0?

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [September 21, 2022, 1:47am UTC](https://discuss.elastic.co/t/boost-based-on-value-of-sum-two-fields/314567/2 "2022-09-21T01:47:21Z")

</div>

What version of Elasticsearch are you running?

---

<div class="post-metadata">

**Author:** ![Ismet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ismet/32/103499_2.png) [@Ismet](https://discuss.elastic.co/u/Ismet)\
**Post date:** [September 21, 2022, 5:01am UTC](https://discuss.elastic.co/t/boost-based-on-value-of-sum-two-fields/314567/3 "2022-09-21T05:01:59Z")

</div>

Elastisearch version 7.10

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [September 21, 2022, 5:51am UTC](https://discuss.elastic.co/t/boost-based-on-value-of-sum-two-fields/314567/4 "2022-09-21T05:51:40Z")

</div>

Runtime fields were added in 7.11.

Given 7.10 is unsupported, as is 7.11, you should be upgrading to 7.17 at a minimum.

---

<div class="post-metadata">

**Author:** ![Ismet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/ismet/32/103499_2.png) [@Ismet](https://discuss.elastic.co/u/Ismet)\
**Post date:** [September 30, 2022, 8:23am UTC](https://discuss.elastic.co/t/boost-based-on-value-of-sum-two-fields/314567/5 "2022-09-30T08:23:34Z")

</div>

Thanks.

Is there some other solution for boosting sum of two fields like

- inventory.warehouse1.availableInventory: 10
- inventory.warehouse2.availableInventory: 20

---

<div class="post-metadata">

**Author:** ![Christian\_Dahlqvist](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/christian_dahlqvist/32/4617_2.png) [@Christian\_Dahlqvist](https://discuss.elastic.co/u/Christian_Dahlqvist)\
**Post date:** [September 30, 2022, 8:42am UTC](https://discuss.elastic.co/t/boost-based-on-value-of-sum-two-fields/314567/6 "2022-09-30T08:42:14Z")

</div>

You could naturally index the sum in a separate field and boost on that, but apart from that I am not aware of any other solution on 7.10. I would recommend upgrading to get access to runtime fields.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 28, 2022, 8:42am UTC](https://discuss.elastic.co/t/boost-based-on-value-of-sum-two-fields/314567/7 "2022-10-28T08:42:41Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.