yii2 andFilterWhere

            //$hSQL->andFilterWhere(['like', '[fo].name', Yii::$app->request->get('filter')['name']])
            $hSQL->andFilterWhere(['like', '[fo].name', Yii::$app->request->get('filter')['name'].'%',false])
            //->where(['like', 'user', $this->username );
$hSQL->andWhere(
            'CONVERT(DATE,[p].date_load)=
            CONVERT(DATE,\''.Yii::$app->request->get('filter')['date_load'].'\')'
            );