using jq how to sort array of object

Question

There is an array of json object, using jq how to check if an object exists if so returns the true else false

I tried this but getting error

cat fruits.json | jq '.fruits[]| sort_by(.version)'

I would like to sort by decending order and output the price of the most recent version.

{
    "fruits": [
        {
            "name": "banana",
            "color": "yellow",
            "price": 0.51,
           "version": 1
        },
        {
            "name": "banana",
            "color": "yellow",
            "price": 0.52,
            "version": 2
        }
    ]
}

Something like cat fruits.json | jq '.fruits| sort_by(-.version) | first'? Or am I misunderstanding? — Joachim Isaksson
– Joachim Isaksson, Commented Dec 27, 2021 at 8:03

jpseng · Accepted Answer · 2021-12-27 10:21:34Z

12

cat fruits.json | jq '.fruits | sort_by(-.version)[0].price'

produces:

0.52

edited Dec 27, 2021 at 10:21

answered Dec 27, 2021 at 9:05

jpseng

2,29012 silver badges23 bronze badges

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

1 Comment

Yuri Aug 25 at 11:02

Remove useless cat: jq '.fruits | sort_by(-.version)[0].price' fruits.json

Viettel Solutions · Accepted Answer · 2021-12-27 08:04:07Z

7

You need try like:

.fruits |= sort_by(.version)

Example: https://jqplay.org/s/ntjioYhKWq

Reference sort by keys

answered Dec 27, 2021 at 8:04

Viettel Solutions

1,53715 silver badges23 bronze badges

Collectives™ on Stack Overflow

using jq how to sort array of object

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related