如何使用jq根据内部数组中的值过滤对象数组? [英] How to filter an array of objects based on values in an inner array with jq?
问题描述
输入以下内容:
[
{
"Id": "cb94e7a42732b598ad18a8f27454a886c1aa8bbba6167646d8f064cd86191e2b",
"Names": [
"condescending_jones",
"loving_hoover"
]
},
{
"Id": "186db739b7509eb0114a09e14bcd16bf637019860d23c4fc20e98cbe068b55aa",
"Names": [
"foo_data"
]
},
{
"Id": "a4b7e6f5752d8dcb906a5901f7ab82e403b9dff4eaaeebea767a04bac4aada19",
"Names": [
"jovial_wozniak"
]
},
{
"Id": "76b71c496556912012c20dc3cbd37a54a1f05bffad3d5e92466900a003fbb623",
"Names": [
"bar_data"
]
}
]
我正在尝试使用 jq 构造一个过滤器,该过滤器返回所有带有Id
s的对象不在内部Names
数组中包含数据",并且输出用换行符分隔.对于以上数据,我想要的输出是
I'm trying to construct a filter with jq that returns all objects with Id
s that do not contain "data" in the inner Names
array, with the output being newline-separated. For the above data, the output I'd like is
cb94e7a42732b598ad18a8f27454a886c1aa8bbba6167646d8f064cd86191e2b
a4b7e6f5752d8dcb906a5901f7ab82e403b9dff4eaaeebea767a04bac4aada19
我认为我对此有些了解:
I think I'm somewhat close with this:
(. - select(.Names[] contains("data"))) | .[] .Id
,但是select
过滤器不正确并且无法编译(获取error: syntax error, unexpected IDENT
).
but the select
filter is not correct and it doesn't compile (get error: syntax error, unexpected IDENT
).
推荐答案
非常接近!在select
表达式中,必须在contains
之前使用管道(|
).
Very close! In your select
expression, you have to use a pipe (|
) before contains
.
此过滤器产生预期的输出.
This filter produces the expected output.
. - map(select(.Names[] | contains ("data"))) | .[] .Id
jq食谱给出了语法示例.
根据键的内容过滤对象
例如,我只想要流派键包含"house"的对象.
Filter objects based on the contents of a key
E.g., I only want objects whose genre key contains "house".
$ json='[{"genre":"deep house"}, {"genre": "progressive house"}, {"genre": "dubstep"}]'
$ echo "$json" | jq -c '.[] | select(.genre | contains("house"))'
{"genre":"deep house"}
{"genre":"progressive house"}
Colin D asks how to preserve the JSON structure of the array, so that the final output is a single JSON array rather than a stream of JSON objects.
最简单的方法是将整个表达式包装在数组构造函数中:
The simplest way is to wrap the whole expression in an array constructor:
$ echo "$json" | jq -c '[ .[] | select( .genre | contains("house")) ]'
[{"genre":"deep house"},{"genre":"progressive house"}]
您还可以使用地图功能:
You can also use the map function:
$ echo "$json" | jq -c 'map(select(.genre | contains("house")))'
[{"genre":"deep house"},{"genre":"progressive house"}]
map解压缩输入数组,将过滤器应用于每个元素,然后创建一个新数组.换句话说,map(f)
等同于[.[]|f]
.
map unpacks the input array, applies the filter to every element, and creates a new array. In other words, map(f)
is equivalent to [.[]|f]
.
这篇关于如何使用jq根据内部数组中的值过滤对象数组?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!