Custom filtering

Yii 2.0 General Discussions
1

Is it possible to define custom filter that does not filter out specific rows? I’ve orderlocked - field in the database and all rows that have value 1 for this I would like to show on the GridView even if it would be otherwise filtered out. Thanks.

2

What does your Query/DataProvider code look like at the moment?

3

Almost the same as it comes with basic-configuration, haven’t tweaked that much. Something specific you want to know?

4

You could do something like




$query->orWhere(['orderlocked' => 1])
5

Thanks but this creates WHERE (orderlocked=1) AND statement to the query and will show only the mentioned rows. How to create OR statement?

6

That’s odd. The documentation clearly states

http://www.yiiframework.com/doc-2.0/yii-db-querytrait.html#orWhere()-detail

7

I’ve found that the order in which you place ->*Where() statements matters. I use


        $announceModel = Announcement::find()

                ->where(['>=', 'end_date', time()])

                ->orWhere('end_date IS NULL')

                ->andWhere(['<=', 'start_date', time()])

                ->orderBy('start_date DESC')

                ->all();

This gives me every announcement that the ‘start_date’ has passed AND ‘end_date’ has not come OR ‘end_date’ is NULL (No End Date).

It took awhile to get the order of where() clauses in the right order.

Still having problems with ->select() of a field from a ->joinWith() relation. :(

8

Indeed, it’s odd. Perhaps the order means something here, I don’t know. I’ve spent now quite some trying to fix this issue.

9

This works (finally):




if ($query->where)

{

	$query->orFilterWhere(['=', 'orders.orderlocked', 1]);

}