Quick search
Since v1.7.0
Quick Search
is another table data search method other than filter
, which is used to quickly filter the data you want. The way to open it is as follows:
$grid->quickSearch();
A search box will appear in the header:
Set different search methods by passing different parameters to the quickSearch
method. There are several ways to use them.
Like Search
The first way, by setting the field name for a simple like
query
$grid->quickSearch('title');
// After submitting the model will execute the following query
$model->where('title', 'like', "%{$input}%");
Or do a 'like` query on multiple fields:
$grid->quickSearch('title', 'desc', 'content');
// After submitting the model will execute the following query
$model->where('title', 'like', "%{$input}%")
->orWhere('desc', 'like', "%{$input}%")
->orWhere('content', 'like', "%{$input}%");
Custom Search
The second way gives you more control over your search criteria.
$grid->quickSearch(function ($model, $query) {
$model->where('title', $query)->orWhere('desc', 'like', "%{$query}%");
});
The parameter $query
of the closure is filled in for the content in the search box, and the query in the closure is submitted after the submission.
Quick syntax search
The third way is to refer to the search syntax of Github
for quick search. The calling method is as follows:
// Do not pass parameters
$grid->quickSearch();
Fill in the contents of the search box according to the following syntax, after the submission will be the corresponding query:
Compare Query
title:foo
,title:!foo
$model->where('title', 'foo');
$model->where('title', '!=', 'foo');
rate:>10
, rate:<10
, rate:>=10
, rate:<=10
$model->where('rate', '>', 10);
$model->where('rate', '<', 10);
$model->where('rate', '>=', 10);
$model->where('rate', '<=', 10);
In, NotIn query
status:(1,2,3,4)
, status:!(1,2,3,4)
$model->whereIn('status', [1,2,3,4]);
$model->whereNotIn('status', [1,2,3,4]);
Between Query
score:[1,10]
$model->whereBetween('score', [1, 10]);
Time Date Function Query
created_at:date,2019-06-08
$model->whereDate('created_at', '2019-06-08');
created_at:time, 09:57:45
$model->whereTime('created_at', '09:57:45');
created_at:day,08
$model->whereDay('created_at', '08');
created_at:month,06
$model->whereMonth('created_at', '06');
created_at:year,2019
$model->whereYear('created_at', '2019');
Like Query
content:%Laudantium%
$model->where('content', 'like', 'Laudantium');
Regular query
username:/song/
$model->where('username', 'REGEXP', 'song');
Please use MYSQL regular syntax here
Multi-conditional combination search
You can implement AND query of multiple fields by separating multiple search statements with commas, such as username:%song% status:(1,2,3)
, after running, the following search will be run.
$model->where('username', 'like', '%song%')->whereIn('status', [1, 2, 3]);
If a condition is an OR
query, just add a |
symbol before the statement unit: username:%song% |status:(1,2,3)
$model->where('username', 'like', '%song%')->orWhereIn('status', [1, 2, 3]);
If the filled query text contains spaces, you need to put it in double quotes: updated_at:"2019-06-08 09:57:45"
Label as the name of the query field
If it is not convenient to get the field name, you can directly use the label
name as the query field.
// For example, the header column of `user_status` is set to `user state`.
$grid->column('user_status', 'user status');
Then you can fill in the user status: (1, 2, 3)
to execute the following query
$model->whereIn('user_status', [1, 2, 3]);