json - 如何根据jq中上述数组中对象中元素的值选择/获取对象元素的(对象数组)键？

Question

我有以下输入:

{
  "key1": {
    "subkey1": [
      {
        "filterkey1": "value1",
        "filterkey2": "value2"
      },
      {
        "filterkey1": "value3",
        "filterkey2": "value4"
      }
    ],
    "subkey2": [
      {
        "filterkey1": "value5",
        "filterkey2": "value6"
      },
      {
        "filterkey1": "value7",
        "filterkey2": "value8"
      }
    ],
    "subkey3": [
      {
        "filterkey1": "value1",
        "filterkey2": "value6"
      },
      {
        "filterkey1": "value9",
        "filterkey2": "value4"
      }
    ]
  },
  "key2": {
  }
}

我想获取具有 "value1" 对象的数组的键 key : "filterkey1" .所以在这种情况下，输出必须是:

["subkey1", "subkey3"]

我关心的所有元素都在“key1”对象中。

Answer 1

使用 keys_unsorted 获取子键，并检查它们的值是否有 filterkey1: "value1"配对使用 any :

.key1 | [
    keys_unsorted[] as $k
    | if any(.[$k][]; .filterkey1=="value1")
    then $k 
    else empty end
]