How to Filter by qty


Im new to Yii 2.0, I know how to do filter using gridview in the index.php. but if i want to do something like ‘>0’ in the qty column, how do i do that? it might not ‘>’ + any number but also ‘<’ + any number.

so it will be better if the operator is flexible.

Have you tried simply put operator before number, in column filter of GridView ?


Yes, of course. but it returns as empty eventhough there is records with qty > 0.

Add an andWhere in ActiveQuery to pass to ActiveDataProvider


i think you do not understand my qn. below is my andWhere

$query->andWhere([’>’, ‘qty_no’, $this->qty_no])

how to make ‘>’ flexible?