How to make grouping in mongodb on Yii2 AR?

Question

Yii

How to make grouping in mongodb on Yii2 AR?
ps Tried Product::find()->where(['user_id' => $userID])->group('city_id')->count(); does not work

Answer 1

Hello, you should just re-read https://yiiframework.com.ua/ru/doc/guide/2/db-acti...

Answer 2

Could you at least specify what tools you use to implement AR for mongodb.
There is no grouping in a query in mongodb. For grouping, the aggregate operation is performed.
If your module does not support switching to aggregation, then you will not do this through the model either.
Saw your abstract model that will take this into account and be able to switch from search to aggregation.

Answer 3

Not special in mongoDB but there is no group() method but AR, it is for yii\mongodb\Collection
www.yiiframework.com/doc-2.0/yii-mongodb-collectio...