# How to search in array of json elasticsearch-PHP

**URL:** <https://discuss.elastic.co/t/how-to-search-in-array-of-json-elasticsearch-php/44784>\
**Category:** Elasticsearch\
**Created:** [March 18, 2016, 1:36am UTC](https://discuss.elastic.co/t/how-to-search-in-array-of-json-elasticsearch-php/44784 "2016-03-18T01:36:22Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![jorgerobertodev](https://avatars.discourse-cdn.com/v4/letter/j/ec9cab/32.png) [@jorgerobertodev](https://discuss.elastic.co/u/jorgerobertodev)\
**Post date:** [March 18, 2016, 1:36am UTC](https://discuss.elastic.co/t/how-to-search-in-array-of-json-elasticsearch-php/44784/1 "2016-03-18T01:36:22Z")

</div>

Have this example data:

{  
"id" : "129613",  
"title" : "my city",  
"coveragearea\_without\_cities" : [ {  
"id" : 58,  
"advertisement\_id" : 129613,  
"state\_id" : 11,  
"city\_id" : 1630,  
"created\_at" : "2016-03-16 21:26:40",  
"updated\_at" : "2016-03-16 21:26:40",  
"city" : {  
"id" : 1630,  
"name" : "Belo Horizonte",  
"state\_id" : 11,  
"created\_at" : "2016-03-15 19:37:53",  
"updated\_at" : "2016-03-15 19:37:53"  
},  
"state" : {  
"id" : 11,  
"name" : "Minas Gerais",  
"acronym" : "MG",  
"created\_at" : "2016-03-15 19:37:53",  
"updated\_at" : "2016-03-15 19:37:53"  
}  
}, {  
"id" : 59,  
"advertisement\_id" : 129613,  
"state\_id" : 11,  
"city\_id" : 1983,  
"created\_at" : "2016-03-16 21:26:40",  
"updated\_at" : "2016-03-16 21:26:40",  
"city" : {  
"id" : 1983,  
"name" : "Juiz de Fora",  
"state\_id" : 11,  
"created\_at" : "2016-03-15 19:37:53",  
"updated\_at" : "2016-03-15 19:37:53"  
},  
"state" : {  
"id" : 11,  
"name" : "Minas Gerais",  
"acronym" : "MG",  
"created\_at" : "2016-03-15 19:37:53",  
"updated\_at" : "2016-03-15 19:37:53"  
}  
}, {  
"id" : 60,  
"advertisement\_id" : 129613,  
"state\_id" : 20,  
"city\_id" : null,  
"created\_at" : "2016-03-16 21:26:40",  
"updated\_at" : "2016-03-16 21:26:40",  
"city" : null,  
"state" : {  
"id" : 20,  
"name" : "Rio Grande do Norte",  
"acronym" : "RN",  
"created\_at" : "2016-03-15 19:37:53",  
"updated\_at" : "2016-03-15 19:37:53"  
}  
} ]  
}

How can do search in array json using elasticsearch-PHP ?

---

<div class="post-metadata">

**Author:** ![magnusbaeck](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/magnusbaeck/32/44943_2.png) [@magnusbaeck](https://discuss.elastic.co/u/magnusbaeck)\
**Post date:** [March 19, 2016, 3:24pm UTC](https://discuss.elastic.co/t/how-to-search-in-array-of-json-elasticsearch-php/44784/2 "2016-03-19T15:24:10Z")

</div>

Searching in nested fields and arrays isn't different from searching in fields on the top level, is it? What have you tried so far?

---

<div class="post-metadata">

**Author:** ![jorgerobertodev](https://avatars.discourse-cdn.com/v4/letter/j/ec9cab/32.png) [@jorgerobertodev](https://discuss.elastic.co/u/jorgerobertodev)\
**Post date:** [March 19, 2016, 7:33pm UTC](https://discuss.elastic.co/t/how-to-search-in-array-of-json-elasticsearch-php/44784/3 "2016-03-19T19:33:08Z")

</div>

i'm tried this search:

{  
"index":"advertisements",  
"type":"anounces",  
"body":{  
"sort":[{"premium":{"order":"desc"}}],  
"query":{  
"filtered":{  
"filter":{  
"bool":{  
"should":{  
"match":{"coveragearea\_without\_cities.state.name":"Mimoso do Sul"}  
}  
}  
}  
}  
}  
}  
}

---

<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:06pm UTC](https://discuss.elastic.co/t/how-to-search-in-array-of-json-elasticsearch-php/44784/4 "2017-07-05T23:06:51Z")

</div>