# Why my bool query is not working?

**URL:** <https://discuss.elastic.co/t/why-my-bool-query-is-not-working/7198>\
**Category:** Elasticsearch\
**Created:** [April 2, 2012, 9:31am UTC](https://discuss.elastic.co/t/why-my-bool-query-is-not-working/7198 "2012-04-02T09:31:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Sumit\_Guptaa](https://avatars.discourse-cdn.com/v4/letter/s/e8c25b/32.png) [@Sumit\_Guptaa](https://discuss.elastic.co/u/Sumit_Guptaa)\
**Post date:** [April 2, 2012, 9:31am UTC](https://discuss.elastic.co/t/why-my-bool-query-is-not-working/7198/1 "2012-04-02T09:31:20Z")

</div>

Hi all,

curl -XGET '[http://localhost:9200/amazon/book/\_search](http://localhost:9200/amazon/book/_search)' -d '{  
"query":  
{  
"bool" :  
{  
"must" :[  
{"term":{"name":"call"}},  
{"range":{"pages":{"from":200,"to":300}}}  
],  
"must\_not": [  
{"term":{"book.author.first\_name":"jack"}}  
],  
"should": [  
{"term":{"book.author.last\_name":"london"}}  
]

```
			}
		}
}

```

}'

In this query i am getting SearchphaseExecutionException....

Regards,  
Sumit Gupta

---

<div class="post-metadata">

**Author:** ![Igor\_Motov](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/igor_motov/32/45193_2.png) [@Igor\_Motov](https://discuss.elastic.co/u/Igor_Motov)\
**Post date:** [April 2, 2012, 10:49am UTC](https://discuss.elastic.co/t/why-my-bool-query-is-not-working/7198/2 "2012-04-02T10:49:29Z")

</div>

It would be easier for us to help you if you provided some additional  
details about your problem such as the query that is causing it and the  
error message that you are getting.

On Monday, April 2, 2012 5:31:20 AM UTC-4, Sumit Gupta wrote:

> Hi all,
> 
> i am facing problem in elasticsearch when we accessing bulk data  
> through url query on the other system that is stored in couchdb and  
> indexed by elasticsearch....
> 
> please help me...
> 
> Regards,  
> Sumit Gupta

---

<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 6, 2017, 3:33am UTC](https://discuss.elastic.co/t/why-my-bool-query-is-not-working/7198/3 "2017-07-06T03:33:58Z")

</div>