# In a boolean query can I specify multiple must clauses or a single must clause with multiple terms?

**URL:** https://discuss.elastic.co/t/in-a-boolean-query-can-i-specify-multiple-must-clauses-or-a-single-must-clause-with-multiple-terms/54415
**Category:** Elasticsearch
**Created:** [June 30, 2016, 2:29pm UTC](https://discuss.elastic.co/t/in-a-boolean-query-can-i-specify-multiple-must-clauses-or-a-single-must-clause-with-multiple-terms/54415 "2016-06-30T14:29:10Z")
**Posts on this page:** 5
**Page:** 1

<div class="post-metadata">

### Author: ![Steve\_Suh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/steve_suh/32/10638_2.png) [@Steve\_Suh](https://discuss.elastic.co/u/Steve_Suh)
#### Post date: [June 30, 2016, 2:29pm UTC](https://discuss.elastic.co/t/in-a-boolean-query-can-i-specify-multiple-must-clauses-or-a-single-must-clause-with-multiple-terms/54415/1 "2016-06-30T14:29:10Z")

</div>

Here's my full query. I'm using the Ruby gem for ElasticSearch. I have it currently working with just one must clause and single term in that.

query: { bool: { must: [{ term: { successful: true }}, { term: { account\_id: [self.id](http://self.id)}}]},  
filter: { range: { record\_completed\_at: { gte: begin\_date, lte: end\_date }}}},  
aggregations: {  
deliveries: { date\_histogram: {  
field: "record\_completed\_at", interval: "day", format: "yyyy-MM-dd", min\_doc\_count: 0,  
time\_zone: timezone.identifier,  
extended\_bounds: { min: begin\_date, max: end\_date}}}})

With this modified query I'm getting the following error:  
[400] {"error":{"root\_cause":[{"type":"parse\_exception","reason":"failed to parse search source. expected field name but got [START\_OBJECT]"}],"type":"search\_phase\_execution\_exception","reason":"all shards failed","phase":"query\_fetch","grouped":true,"failed\_shards":[{"shard":0,"index":"roots","node":"613MZvDtSx2fK6jutlo4yg","reason":{"type":"parse\_exception","reason":"failed to parse search source. expected field name but got [START\_OBJECT]"}}]},"status":400}

---

<div class="post-metadata">

### Author: ![Steve\_Suh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/steve_suh/32/10638_2.png) [@Steve\_Suh](https://discuss.elastic.co/u/Steve_Suh)
#### Post date: [June 30, 2016, 2:59pm UTC](https://discuss.elastic.co/t/in-a-boolean-query-can-i-specify-multiple-must-clauses-or-a-single-must-clause-with-multiple-terms/54415/2 "2016-06-30T14:59:43Z")

</div>

Ugh I see my error now. Nevermind.

---

<div class="post-metadata">

### Author: ![cbuescher](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/cbuescher/32/60402_2.png) [@cbuescher](https://discuss.elastic.co/u/cbuescher)
#### Post date: [July 1, 2016, 9:13am UTC](https://discuss.elastic.co/t/in-a-boolean-query-can-i-specify-multiple-must-clauses-or-a-single-must-clause-with-multiple-terms/54415/3 "2016-07-01T09:13:17Z")

</div>

Hi Steve,  
it might be interesting for others what was wrong with your initial approach. So it would be great if you can share your findings.

---

<div class="post-metadata">

### Author: ![Steve\_Suh](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/steve_suh/32/10638_2.png) [@Steve\_Suh](https://discuss.elastic.co/u/Steve_Suh)
#### Post date: [July 1, 2016, 1:15pm UTC](https://discuss.elastic.co/t/in-a-boolean-query-can-i-specify-multiple-must-clauses-or-a-single-must-clause-with-multiple-terms/54415/4 "2016-07-01T13:15:06Z")

</div>

I had an extra curly after the ].

---

<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, 10:38pm UTC](https://discuss.elastic.co/t/in-a-boolean-query-can-i-specify-multiple-must-clauses-or-a-single-must-clause-with-multiple-terms/54415/5 "2017-07-05T22:38:57Z")

</div>


