Sort hasMany relation in Yii2

Question

I have a simple relation 1:N to get some prices from a single model.

public function getPrices()
    {
        return $this->hasMany(Prices::className(), ['device_id' => 'id']);
    }

But I need prices objects sorteds by a specific property in this case $value

I've seen multiple examples in Yii 1 but nothing in Yii 2

Thanks to @vishu i've tried this:

public function getPrices()
{
    return $this->hasMany(Prices::className(), ['device_id' => 'id'])
        ->viaTable(Prices::tableName(), ['device_id' => 'id'], function ($query) {

            $query->orderBy(['device_price' => SORT_DESC]);
        });

}

But now it returns a empty array.

ScaisEdge · Accepted Answer · 2017-05-31T18:16:52.843

32

I think you can assign the order by directly in relation

public function getPrices()
{
    return $this->hasMany(Prices::className(), ['device_id' => 'id'])->
      orderBy(['device_price' => SORT_DESC]);
}

edited May 31 '17 at 18:16

answered Dec 30 '15 at 16:32

ScaisEdge

131,976
10
91
107

Very useful to get another type of data since it returns an AR obj, such as user's last transaction : `orderBy('created_at DESC')->one();` – Prabowo Murti Oct 05 '21 at 05:26

score 3 · Answer 2 · answered Jan 28 '18 at 08:20

3

Setting order directly in relation may not be reliable in particular cases. So you can set order in AR query

Device::find()
->where(['id' => $id])
->with('prices' => function(\yii\db\ActiveQuery $query) {
    $query->orderBy('device_price DESC');
})
->one();

answered Jan 28 '18 at 08:20

vkabachenko

251
3
5

1

inside the with() are Bracktes missing [] – kasoft Oct 11 '18 at 11:58

vishuB · Answer 3 · 2019-02-19T11:33:02.927

1

Use like.......

public function getPrices()
{
    return $this->hasMany(Prices::className(), ['device_id' => 'id'])
                ->orderBy(['device_price' => SORT_DESC]);
 }

Reference

edited Feb 19 '19 at 11:33

answered Dec 30 '15 at 11:54

vishuB

4,173
5
31
49

check your id and then run? – vishuB Dec 30 '15 at 12:12
check this compare id `['device_id' => 'id']` – vishuB Dec 30 '15 at 12:33
wich?, hasMany relation, viaTable? or I have to set it in andWhere clousure? – Sageth Dec 30 '15 at 12:36
refer this link....http://stackoverflow.com/questions/27690401/activerecord-where-and-order-on-via-table – vishuB Dec 30 '15 at 12:52
But in this link, he had a N:M relation, and i have 1:N – Sageth Dec 30 '15 at 12:56

Sort hasMany relation in Yii2

3 Answers3