# Elasticsearch "OR" condition query

**URL:** <https://discuss.elastic.co/t/elasticsearch-or-condition-query/252531>\
**Category:** Elasticsearch\
**Created:** [October 19, 2020, 11:07am UTC](https://discuss.elastic.co/t/elasticsearch-or-condition-query/252531 "2020-10-19T11:07:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Yotam\_Mazurik](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yotam_mazurik/32/51497_2.png) [@Yotam\_Mazurik](https://discuss.elastic.co/u/Yotam_Mazurik)\
**Post date:** [October 19, 2020, 11:07am UTC](https://discuss.elastic.co/t/elasticsearch-or-condition-query/252531/1 "2020-10-19T11:07:52Z")

</div>

Hi!  
I am trying to query an index with two different document fieldsets.  
to be more specific, I am trying to query all documents where field1 is equal to field2 but field1 and field2 will never exists in the same document.  
my achievment is to query both types of document where my "KEY" is the field's value.  
is it possible?

doc\_type1:

```auto
event: 1234
name: new_events

```

doc\_type2:

```auto
event_id: 1234
 name: events

```

i would like to recive an output of both types of documents!

---

<div class="post-metadata">

**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\
**Post date:** [October 19, 2020, 11:19am UTC](https://discuss.elastic.co/t/elasticsearch-or-condition-query/252531/2 "2020-10-19T11:19:52Z")

</div>

Just to make sure I properly understand. You are basically trying to query for `event:1234 or event_id:1234`? This can be done with a [boolean query](https://www.elastic.co/guide/en/elasticsearch/reference/7.9/query-dsl-bool-query.html).

If you do not know the value of `1234` upfront, then you may want to rethink your index strategy/data modeling strategy. Another thing to look at is the [join field type](https://www.elastic.co/guide/en/elasticsearch/reference/7.9/parent-join.html)

---

<div class="post-metadata">

**Author:** ![Yotam\_Mazurik](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/yotam_mazurik/32/51497_2.png) [@Yotam\_Mazurik](https://discuss.elastic.co/u/Yotam_Mazurik)\
**Post date:** [October 19, 2020, 12:35pm UTC](https://discuss.elastic.co/t/elasticsearch-or-condition-query/252531/3 "2020-10-19T12:35:17Z")

</div>

thank you for responding so quickly,  
the problem is that I don't know the value of `1234` upfront.  
join field type is not the solution i am looking for,  
you may use it only once per index...

any other suggestions?

---

<div class="post-metadata">

**Author:** ![spinscale](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/spinscale/32/25011_2.png) [@spinscale](https://discuss.elastic.co/u/spinscale)\
**Post date:** [October 21, 2020, 7:49am UTC](https://discuss.elastic.co/t/elasticsearch-or-condition-query/252531/4 "2020-10-21T07:49:05Z")

</div>

Then denormalization might be the way to go... one last straw may be taking a look at [transforms](https://www.elastic.co/guide/en/elasticsearch/reference/7.9/transform-overview.html), but I am not sure if that fits your use-case - still worth checking it out.

---

<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:** [November 18, 2020, 7:49am UTC](https://discuss.elastic.co/t/elasticsearch-or-condition-query/252531/5 "2020-11-18T07:49:18Z")

</div>

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