Since v.1.7.2
This feature sets a filter for the corresponding column in the header, which makes it easier to perform data table filtering based on this column.
There are three types of filters:
$grid->column('code')->filter();
The above call can add a input
type filter to the header of the code
column. Click the filter icon to expand the filter. After the query is submitted, the equal
query will be executed for this column.
If you need a like query:
$grid->column('title')->filter('like');
If the field is a time, date related field, you can use the following method
$grid->column('date')->filter('date');
$grid->column('time')->filter('time');
$grid->column('datetime')->filter('datetime');
Suppose you need to filter one or more status data in the table data through the status
field. It is very convenient to use Multiple select query
.
$grid->column('status')->filter([
0 => 'Unknown',
1 => 'Ordered',
2 => 'Paid',
3 => 'Cancelled',
]);
Suppose you need to filter out data in a price range by using the price
field.
$grid->column('price')->filter('range');
Or filtering of time and date range
$grid->column('date')->filter('range', 'date');
$grid->column('time')->filter('range', 'time');
$grid->column('datetime')->filter('range', 'datetime');