$query = ModelName::find()
->select([
'outcome_planned.*',
'COALESCE(SUM(outcome.value), 0) AS public_field_name'
])
->with('user')
->joinWith(['outcomes'])
->groupBy('outcome_planned.id')
->orderBy(['outcome_planned.date' => SORT_DESC]);
$dataProvider = new ActiveDataProvider([
'query' => $query,
'pagination' => [
'pageSize' => 100,
],
'sort' => false
]);
Find more questions by tags Yii
$query->andFilterWhere([
'id' => $this->id,
// other attr
'Status' => 'blabla', <- here ?
]);
PS: search model generirovanie gii - watson_Torphy commented on July 9th 19 at 10:21
$query->addSelect(["*", "CONCAT(first_name,' ', last_name) AS full_name"])->one(); - burnice commented on July 9th 19 at 10:24