How to order collection by json attribute in Laravel

Question

In my code, i have a collection object. One part of the collection object is structured as follows

"id" => 1
"rate" => "{"p_1":"1","p_2":"2","p_3":"2.3","p_4":"3.5"}"
"currency" => 1
"desc" => "TEST"

In the above instance i have a key called rate, which has a json string as value.

What i want to do is sort the collection object by value p_1 contained in the range key.

Your question is unclear. In what way do you want to order p_1 in rate? — Nicola Worthington
– Nicola Worthington, Commented Oct 25, 2017 at 13:15
@NicolaWorthington i want to order all the objects of the collection by the p_1. — AM DEV
– AM DEV, Commented Oct 25, 2017 at 13:19

ntzm · Accepted Answer · 2017-10-25 14:50:00Z

2

You have to decode the JSON string before ordering:

$collection->sortBy(function(array $item) {
    return json_decode($item->rate)->p_1;
});

answered Oct 25, 2017 at 14:50

ntzm

4,8692 gold badges34 silver badges39 bronze badges

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

Comments

Niklesh Raut · Accepted Answer · 2017-10-25 13:19:23Z

1

Use sortBy() to sort collection in laravel

$collection->sortBy(function($item) {
  return $item->rate->p_1;
});

here $collection is your laravel result which gives by default, you can explicitly convert it by using collect method as well

Check docs for more details

answered Oct 25, 2017 at 13:19

Niklesh Raut

34.9k17 gold badges82 silver badges112 bronze badges