sort relation model count yii2
Sorting a Yii2 Relation Model Count
To sort a Yii2 relation model count, you can use the withCount()
method in Yii2. This method allows you to retrieve the count of related records and sort them accordingly.
Here's an example of how you can use withCount()
to sort a relation model count in Yii2:
$models = Model::find()
->withCount(['relation'])
->orderBy(['relation_count' => SORT_DESC])
->all();
In this example, Model
represents the model you want to retrieve, and relation
represents the relation you want to count and sort by. The withCount()
method retrieves the count of related records and assigns it to the relation_count
attribute. The orderBy()
method is used to sort the models based on the relation_count
attribute in descending order.
Please note that you need to replace Model
with the actual name of your model class and relation
with the name of your relation.
I hope this helps! Let me know if you have any further questions.