ansible - how to use json_query filter to extract all items equals to a value

Question

Here is my json output:

{
"kind": [
    {
        "inventory": "",
        "inventory_sources": "",
        "job_templates": "",
        "workflow_job_templates": "104"
    },
    {
        "inventory": "",
        "inventory_sources": "",
        "job_templates": "114",
        "workflow_job_templates": ""
    },
    {
        "inventory": "24",
        "inventory_sources": "",
        "job_templates": "",
        "workflow_job_templates": ""
    },
    {
        "inventory": "",
        "inventory_sources": "108",
        "job_templates": "",
        "workflow_job_templates": ""
    }
]

}

I'd like to display all items name that contain a specific value. For instance, I'd like to display that the item name taht contain '104' is 'workflow_job_templates'

I tested some syntaxes without any success:

    - debug: 
      msg: "104 is {{kind|json_query(query)}}"
      vars:
        query: "[?*==`104`].workflow_job_templates"

I know it is a wrong way to do but can someone tell me how he'd do for himself?

question from:https://stackoverflow.com/questions/65903446/how-to-use-json-query-filter-to-extract-all-items-equals-to-a-value

Answer 1

^(Update)

The task below

    - debug:
        msg: "{{ item }} {{ kind|
                            map('dict2items')|
                            map('json_query', query)|
                            flatten }}"
      loop: [104, 114, 108, 24]
      vars:
        query: "[?to_string(value) == to_string('{{ item }}')].key"

gives

  msg: 104 ['workflow_job_templates']
  msg: 114 ['job_templates']
  msg: 108 ['inventory_sources']
  msg: 24 ['inventory']

---

^{(For the record. Brute-force approach)}

Create a unique list of the keys

    - set_fact:
        my_keys: "{{ my_keys|default([]) + item.keys()|list }}"
      loop: "{{ kind }}"
    - set_fact:
        my_keys: "{{ my_keys|unique }}"

gives

  my_keys:
  - inventory
  - inventory_sources
  - job_templates
  - workflow_job_templates

Create a dictionary with all values

    - set_fact:
        my_dict: "{{ my_dict|default({})|combine({item: values}) }}"
      loop: "{{ my_keys }}"
      vars:
        query: "[].{{ item }}"
        values: "{{ kind|json_query(query) }}"

gives

  my_dict:
    inventory:
    - ''
    - ''
    - '24'
    - ''
    inventory_sources:
    - ''
    - ''
    - ''
    - '108'
    job_templates:
    - ''
    - '114'
    - ''
    - ''
    workflow_job_templates:
    - '104'
    - ''
    - ''
    - ''

Then search the dictionary. For example

    - debug:
        msg: "{{ item }} {{ my_dict|dict2items|json_query(query) }}"
      loop: [104, 114, 108, 24]
      vars:
        query: "[?value[?contains(@, '{{ item }}')]].key"

gives

  msg: 104 ['workflow_job_templates']
  msg: 114 ['job_templates']
  msg: 108 ['inventory_sources']
  msg: 24 ['inventory']