# Exclude json object which doesn't have value in ansible

**URL:** <https://forum.ansible.com/t/exclude-json-object-which-doesnt-have-value-in-ansible/34384>\
**Category:** Ansible Project\
**Created:** [December 31, 2020, 9:53pm UTC](https://forum.ansible.com/t/exclude-json-object-which-doesnt-have-value-in-ansible/34384 "2020-12-31T21:53:57Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ramesh\_AR](https://avatars.discourse-cdn.com/v4/letter/r/3e96dc/32.png) [@Ramesh\_AR](https://forum.ansible.com/u/Ramesh_AR)\
**Post date:** [December 31, 2020, 9:53pm UTC](https://forum.ansible.com/t/exclude-json-object-which-doesnt-have-value-in-ansible/34384/1 "2020-12-31T21:53:57Z")

</div>

1. how to exclude the below from json queries or is it possible to filter in debug . I tried but couldn’t sorted out .

---

<div class="post-metadata">

**Author:** ![Dick\_Visser](https://avatars.discourse-cdn.com/v4/letter/d/d9b06d/32.png) [@Dick\_Visser](https://forum.ansible.com/u/Dick_Visser)\
**Post date:** [December 31, 2020, 10:57pm UTC](https://forum.ansible.com/t/exclude-json-object-which-doesnt-have-value-in-ansible/34384/2 "2020-12-31T22:57:52Z")

</div>

[https://docs.ansible.com/ansible/latest/user\_guide/playbooks\_filters.html#formatting-data-yaml-and-json](https://docs.ansible.com/ansible/latest/user_guide/playbooks_filters.html#formatting-data-yaml-and-json)

---

<div class="post-metadata">

**Author:** ![Ramesh\_AR](https://avatars.discourse-cdn.com/v4/letter/r/3e96dc/32.png) [@Ramesh\_AR](https://forum.ansible.com/u/Ramesh_AR)\
**Post date:** [January 4, 2021, 10:40pm UTC](https://forum.ansible.com/t/exclude-json-object-which-doesnt-have-value-in-ansible/34384/3 "2021-01-04T22:40:10Z")

</div>

can someone help me on how to remove **inactive user** from the below debug output,

TASK [debug] \*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*  
ok: [host1] =\> {}

MSG:

- {accountStatus: active, id: ‘1’, name: admin, priv: admin}
- {accountStatus: active, id: ‘2’, name: VIDEO, priv: admin}
- {accountStatus: active, id: ‘3’, name: CDVR, priv: admin}
- {accountStatus: active, id: ‘4’, name: VIP, priv: admin}
- {accountStatus: active, id: ‘5’, name: vie, priv: admin}
- {accountStatus: active, id: ‘6’, name: op5, priv: admin}
- {accountStatus: active, id: ‘7’, name: DEU, priv: admin}
- {accountStatus: active, id: ‘8’, name: syn, priv: admin}
- {accountStatus: inactive, id: ‘9’, name: ‘’, priv: ‘’}
- {accountStatus: inactive, id: ‘10’, name: ‘’, priv: ‘’}
- {accountStatus: inactive, id: ‘11’, name: ‘’, priv: ‘’}
- {accountStatus: inactive, id: ‘12’, name: ‘’, priv: ‘’}
- {accountStatus: inactive, id: ‘13’, name: ‘’, priv: ‘’}
- {accountStatus: inactive, id: ‘14’, name: ‘’, priv: ‘’}
- {accountStatus: inactive, id: ‘15’, name: ‘’, priv: ‘’}

Playbook:

register: result

- set\_fact:  
user: “{{ result.configResolveClass.children|json\_query(my\_query) }}”  
vars:  
my\_query: “.outConfigs.children.aaaUser.attributes.{id: id, name: name, priv: priv, accountStatus: accountStatus}”
- debug:  
msg: “{{ user | to\_yaml }}”

---

<div class="post-metadata">

**Author:** ![vbotka](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/vbotka/32/359_2.png) [@vbotka](https://forum.ansible.com/u/vbotka)\
**Post date:** [January 5, 2021, 1:56am UTC](https://forum.ansible.com/t/exclude-json-object-which-doesnt-have-value-in-ansible/34384/4 "2021-01-05T01:56:28Z")

</div>

Try this

&nbsp;&nbsp;&nbsp;&nbsp;- debug:  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;msg: "{{ user|  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;rejectattr('accountStatus', 'eq', 'inactive')|  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;list }}"

---

<div class="post-metadata">

**Author:** ![Ramesh\_AR](https://avatars.discourse-cdn.com/v4/letter/r/3e96dc/32.png) [@Ramesh\_AR](https://forum.ansible.com/u/Ramesh_AR)\
**Post date:** [January 5, 2021, 3:13pm UTC](https://forum.ansible.com/t/exclude-json-object-which-doesnt-have-value-in-ansible/34384/5 "2021-01-05T15:13:32Z")

</div>

Thank you so much Vlado… Worked fine .