# Compare fields in two documents

**URL:** <https://discuss.elastic.co/t/compare-fields-in-two-documents/26249>\
**Category:** Elasticsearch\
**Created:** [July 24, 2015, 2:30pm UTC](https://discuss.elastic.co/t/compare-fields-in-two-documents/26249 "2015-07-24T14:30:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![karolpivo](https://avatars.discourse-cdn.com/v4/letter/k/8e7dd6/32.png) [@karolpivo](https://discuss.elastic.co/u/karolpivo)\
**Post date:** [July 24, 2015, 2:30pm UTC](https://discuss.elastic.co/t/compare-fields-in-two-documents/26249/1 "2015-07-24T14:30:43Z")

</div>

I want to compare specific field of two documents in a single index. Based on my research the way to do this is to use scripting module. The script will evaluate if the fields are the same, something like this should do doc99['field\_name'].value == doc100['field\_name'].value.

Is this even possible?

The purpose is to only show document if specific field has changed comparing to the previous document and show on dashboard.

Thanks

---

<div class="post-metadata">

**Author:** ![PatrickKik](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/patrickkik/32/619_2.png) [@PatrickKik](https://discuss.elastic.co/u/PatrickKik)\
**Post date:** [July 27, 2015, 5:19am UTC](https://discuss.elastic.co/t/compare-fields-in-two-documents/26249/2 "2015-07-27T05:19:19Z")

</div>

Usually all actions (queries, filters, scripts) are used within one aggregate. It is not the preferred way to go to do a 'join'.

---

<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:** [July 5, 2017, 11:58pm UTC](https://discuss.elastic.co/t/compare-fields-in-two-documents/26249/3 "2017-07-05T23:58:54Z")

</div>