jq sort using the value of a nested array element

Question

I need some help using jq to sort an array of elements where each element contains a nested tags array of elements. My input JSON looks like this:

{
  "result": [
    {
      "name": "ct-1",
      "tags": [
        {
          "key": "service_name",
          "value": "BaseCT"
        },
        {
          "key": "sequence",
          "value": "bb"
        }
      ]
    },
    {
      "name": "ct-2",
      "tags": [
        {
          "key": "service_name",
          "value": "BaseCT"
        },
        {
          "key": "sequence",
          "value": "aa"
        }
      ]
    }
  ]
}

I would like to sort using the value of the sequence tag in the nested tags array so that the output looks like this:

{
  "result": [
    {
      "name": "ct-2",
      "tags": [
        {
          "key": "service_name",
          "value": "BaseCT"
        },
        {
          "key": "sequence",
          "value": "aa"
        }
      ]
    },
    {
      "name": "ct-1",
      "tags": [
        {
          "key": "service_name",
          "value": "BaseCT"
        },
        {
          "key": "sequence",
          "value": "bb"
        }
      ]
    }
  ]
}

I have tried the following jq command:

$ jq '.result |= ([.[] | .tags[] | select(.key == "sequence") | .value] | sort_by(.))' input.json

but I get the following result:

{
  "result": [
    "aa",
    "bb"
   ]
}

Please let me know if you know how to deal with this scenario.

oguz ismail · Accepted Answer · 2019-11-01 20:49:12Z

7

from_entries converts an array of key-value pairs to an object, you can use it with sort_by like this:

.result |= sort_by(.tags | from_entries | .sequence)

answered Nov 1, 2019 at 20:49

oguz ismail

51.8k16 gold badges64 silver badges83 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

jq sort using the value of a nested array element

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related