JQ-打印特定键值对

Question

我有这个 JSON：

{
    "time": "2022-02-28T22:00:55.196Z",
    "severity": "INFO",
    "params": [
        {"key": "state", "value": "pending"},
        {"key": "options", "value": "request"},
        {"key": "description", "value": "[FILTERED]"}
    ],
    "content_length": "231"
}

我想打印键与状态和选项以及时间及其值匹配的键值对。我可以使用以下命令打印时间和所有键值对，但不确定如何提取特定的键值对。

jq '"time:\(.time)" ,[.params[] | "key:\(.key)" ,"value:\(.value)"]' test.json

这给出了输出：

"time:2022-02-28T22:00:55.196Z"
[
  "key:state",
  "value:pending",
  "key:options",
  "value:request",
  "key:description",
  "value:[FILTERED]"
]

但我想要的输出是：

"time:2022-02-28T22:00:55.196Z"
  "key:state",
  "value:pending",
  "key:options",
  "value:request"

Answer 1

上述问题的一种解决方案是：

< test.json jq ' 
  "time:\(.time)",
  [.params[] | select(.key|IN("state","options"))
   | "key:\(.key)" ,"value:\(.value)"]
' | sed '/^[][]$/d'

但是，几乎可以肯定的是，稍微修改一下要求，使输出格式不那么特殊。这也将使制定更清晰的（例如 only-jq）解决方案变得更加容易。

Answer 2

您可以使用@csv（逗号分隔值）。

过滤器

"time:\(.time)", 
(.params | 
[map(select(.key=="state" or .key=="options"))[] 
| "key:\(.key)", "value:\(.value)"] 
| @csv)

输入

{
    "time": "2022-02-28T22:00:55.196Z",
    "severity": "INFO",
    "params": [
        {"key": "state", "value": "pending"},
        {"key": "options", "value": "request"},
        {"key": "description", "value": "[FILTERED]"}
    ],
    "content_length": "231"
}

输出

time:2022-02-28T22:00:55.196Z
"key:state","value:pending","key:options","value:request"

演示

https://jqplay.org/s/F_3QP6-EvK