Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

yii2 ActiveRecord Find OrderBy with calculation

Trying to fetch a description from my database. The query returns the result but I would like to order the result to only show the one with the highest vote.

The vote should be calculated by the upvoted column subtracted by the downvoted column

$description = UnitDescription::find()
   ->where(['id_unit' => $model->id])
   ->orderBy([
      'upvoted - downvoted' => SORT_DESC //Need this line to be fixed
   ])
   ->one();

I was hoping someone might have a way to write this part of the query - Thanks

like image 928
william Avatar asked Jan 04 '16 10:01

william


1 Answers

You should simply try :

$description = UnitDescription::find()
    ->where(['id_unit' => $model->id])
    ->orderBy(['(upvoted - downvoted)' => SORT_DESC])
    ->one();
like image 101
soju Avatar answered Oct 19 '22 19:10

soju