# Not getting every datas in nested json filter

**URL:** https://discuss.elastic.co/t/not-getting-every-datas-in-nested-json-filter/153386
**Category:** Logstash
**Created:** [October 22, 2018, 11:26am UTC](https://discuss.elastic.co/t/not-getting-every-datas-in-nested-json-filter/153386 "2018-10-22T11:26:15Z")
**Posts on this page:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Balamurali](https://avatars.discourse-cdn.com/v4/letter/b/90db22/32.png) [@Balamurali](https://discuss.elastic.co/u/Balamurali)
#### Post date: [October 22, 2018, 11:26am UTC](https://discuss.elastic.co/t/not-getting-every-datas-in-nested-json-filter/153386/1 "2018-10-22T11:26:16Z")

</div>

Hi Team,

We are using logstash 6.4 version and **not getting every data in nested JSON filter**.

**_Sample data:_**

> {"from":0,"size":1000,"query":{"bool":{"must":[{"term":{"companyId":12484}},{"term":{"aroundid":22}},{"term":{"loyalType.id":12}}]}},"sort":[{"group\_name":{"order":"asc"}}]}  
> {"from":0,"size":1000,"query":{"bool":{"must":[{"term":{"companyId":32484}},{"term":{"aroundid":23}},{"term":{"loyalType.id":57}}]}},"sort":[{"group\_name":{"order":"asc"}}]}  
> {"from":0,"size":1000,"query":{"bool":{"must":[{"term":{"companyId":52484}},{"term":{"aroundid":42}},{"term":{"loyalType.id":34}}]}},"sort":[{"group\_name":{"order":"asc"}}]}

**_Below Result I got_** :

> **from** : 0

> **size** : 1000

> **query.bool.must** : " {  
> "term": {  
> "companyId": 12484  
> }  
> },  
> {  
> "term": {  
> "aroundid": 22  
> }  
> },  
> {  
> "term": {  
> "loyalType.id": 12  
> }  
> }"

> **sort** : " {  
> "group\_name": {  
> "order": "asc"  
> }  
> }"

But my requirement is needed to get field values 's for "companyId" , "aroundid" in separate fields.

Please help on this.

---

<div class="post-metadata">

### Author: ![Balamurali](https://avatars.discourse-cdn.com/v4/letter/b/90db22/32.png) [@Balamurali](https://discuss.elastic.co/u/Balamurali)
#### Post date: [October 29, 2018, 6:07am UTC](https://discuss.elastic.co/t/not-getting-every-datas-in-nested-json-filter/153386/2 "2018-10-29T06:07:49Z")

</div>

Anyone know this?

---

<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 26, 2018, 6:07am UTC](https://discuss.elastic.co/t/not-getting-every-datas-in-nested-json-filter/153386/3 "2018-11-26T06:07:52Z")

</div>

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