我想使用 ansible 中的 json_query 将两个属性组合成由分隔符分隔的单个字符串
样本数据
{
"locations": [
{"name": "Seattle", "state": "WA"},
{"name": "New York", "state": "NY"},
{"name": "Bellevue", "state": "WA"},
{"name": "Olympia", "state": "WA"}
]
}
如上面的数据集所示,我试图过滤状态“WA”,执行的输出是:
[
"Seattle-WA",
"Bellevue-WA",
"Olympia-WA"
]
到目前为止我已经尝试过的:
- debug:
msg: "{{ chart_list.HELM_CHARTS | json_query(\"[?state == 'WA'].{name:name,state:state}\") }}"
Output:
[
{
"name": "Seattle",
"state": "WA"
},
{
"name": "Bellevue",
"state": "WA"
},
{
"name": "Olympia",
"state": "WA"
}
]
更新 :我通过反复试验的方法得到了预期的结果,这些是我的发现:
[?state == 'WA'].[join('-',[name,state])][]
Output:
[
"Seattle-WA",
"Bellevue-WA",
"Olympia-WA"
]
另外,如果您提供的输入是 unicode 格式,我建议您添加to_json | from_json
表达式如下:
selected_cities: "{{ test.locations| to_json | from_json | json_query(\"[?state == 'WA'].[join('-',[name,state])][]\") }}"
使用上述表达式将消除使用值或在任何条件下的 unicode 错误。
查看JMESPath https://jmespath.org/有关 json_query 的更多详细信息,它对于解决问题确实很有帮助。