# Problem with json\_query to search number

**URL:** <https://forum.ansible.com/t/problem-with-json-query-to-search-number/34565>\
**Category:** Ansible Project\
**Created:** [February 4, 2021, 8:22am UTC](https://forum.ansible.com/t/problem-with-json-query-to-search-number/34565 "2021-02-04T08:22:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Danny\_van\_der\_Aa](https://avatars.discourse-cdn.com/v4/letter/d/46a35a/32.png) [@Danny\_van\_der\_Aa](https://forum.ansible.com/u/Danny_van_der_Aa)\
**Post date:** [February 4, 2021, 8:22am UTC](https://forum.ansible.com/t/problem-with-json-query-to-search-number/34565/1 "2021-02-04T08:22:05Z")

</div>

Hi all,

I am trying to search for a number with a json\_query but result is always “”.

Part of JSON is:

“json”: {  
“code”: 200,  
“success”: true,  
“data”: [  
{  
“vlanId”: “430”,  
“domainId”: “3”,  
“name”: “Default”,  
“number”: “1”,  
“description”: “Default VLAN”,  
“editDate”: null,  
“customer\_id”: null,  
“custom\_Topdesk”: null  
},  
{  
“vlanId”: “431”,  
“domainId”: “3”,  
“name”: “vlanname”,  
“number”: “3”,  
“description”: " vlanname ",  
“editDate”: null,  
“customer\_id”: null,  
“custom\_Topdesk”: null  
},

Ansible command i am using is:

- name: Determine VLAN ID  
set\_fact:  
vlan\_id: “{{ ipam\_vlans\_filterby\_domainid.content.data }} | json\_query(‘[? number == `~ vlan ~`]|[0].vlanId’) }}”

variabele vlan for example is: “3”

I found on internet there are some bugs regarding this and some work arounds but not able to get it solved.  
Does some one has an idea?

Kind regards,

Danny

---

<div class="post-metadata">

**Author:** ![Akasurde](https://sea1.discourse-cdn.com/ansible/user_avatar/forum.ansible.com/akasurde/32/230_2.png) [@Akasurde](https://forum.ansible.com/u/Akasurde)\
**Post date:** [February 4, 2021, 8:54am UTC](https://forum.ansible.com/t/problem-with-json-query-to-search-number/34565/2 "2021-02-04T08:54:46Z")

</div>

Try like

- debug:  
msg: ‘{{ data | json\_query(query) }}’  
vars:  
query: ‘[?number==`"{{ vlan }}"`]’