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, Dec 27 '21 at 08:03

jpseng · Accepted Answer · 2021-12-27T10:21:34.427

3

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

produces:

0.52

edited Dec 27 '21 at 10:21

answered Dec 27 '21 at 09:05

jpseng

1,618
6
18

score 1 · Answer 2 · answered Dec 27 '21 at 08:04

1

You need try like:

.fruits |= sort_by(.version)

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

Reference sort by keys

answered Dec 27 '21 at 08:04

Viettel Solutions

1,519
11
22

using jq how to sort array of object

2 Answers2