带有包含的json格式查询 [英] json format query with contains
问题描述
我在ansible中有以下json输出:
I have the following json output in ansible:
[{
"active_transaction": null,
"cores": 4,
"hostname": "alpha-auth-wb01"
},
{
"active_transaction": null,
"cores": 4,
"hostname": "beta-auth-wb01"
}]
现在我正在尝试过滤输出以仅显示主机名包含 alpha 的输出.
Now I am trying to filter the output to just show the output where the hostname contains alpha for example.
输出应该是:
[{
"active_transaction": null,
"cores": 4,
"hostname": "alpha-auth-wb01"
}]
代码和结果:
jq: "[?contains(hostname, 'alpha')]"
fatal: [worker.domain]: FAILED! => {"msg": "JMESPathError in json_query filter plugin:\\nIn function contains(), invalid type for value: None, expected one of: ['array', 'string'], received: \\"null\\""}
还尝试添加 from_json |to_json 反之亦然.还是失败了.
Also tried adding from_json | to_json and the other way around. Still fails.
任何想法都非常感谢!
推荐答案
正如@Matthew L Daniel 提到的,由于引用问题,您应该将查询存储在变量中.您的查询也是不正确的,对于您想要的.据我了解,您希望选择所有元素,其中 hostname
包含字符串 alpha
.一个完全有效的解决方案如下:
As @Matthew L Daniel mentioned, you should store your query in a variable, because of quoting issues. Also your query is incorrect, for what you want. As I understood, you would like to select all elements, where the hostname
contains the string alpha
. A fully working solution is the following:
---
- hosts: localhost
gather_facts: False
vars:
jq: "[?contains(hostname, 'alpha')]"
json: |
[{
"active_transaction": null,
"cores": 4,
"hostname": "alpha-auth-wb01"
},
{
"active_transaction": null,
"cores": 4,
"hostname": "beta-auth-wb01"
}]
tasks:
- name: DEBUG
debug:
msg: "{{ json | from_json | json_query(jq) }}"
如果您不想在 var 中编写 json_query
,您可以像这样引用它:
If you don't want to write your json_query
in a var you could quote it like this:
"{{ json | json_query(\"[?contains(hostname, 'alpha')]\") }}"
但我建议将其放入 var 中.
But I would recommend, to put it in a var.
这篇关于带有包含的json格式查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!