Search in multiple fields about eloquence HOT 4 CLOSED

Will be easier if you show me real example. Basically you can prepare the search query by yourself, the way you need it. For example:

$query = [];
$query[] = $input->get('firstname') . ' ' . $input->get('lastname');
$query[] = $input->get('lastname') . ' ' . $input->get('firstname');

// if you're passing array instead of string as $query, then it's going to search phrases:
`name` like '%jarek tkaczyk%' or `name` like '%tkaczyk jarek%' ...

from eloquence.

It doesn't work :/

Column not found: 1054 Champ 'clients.firstname lastname' inconnu dans field list

$query = [];
$input = [];

/*if($request->get('company_name')) {
    $query[] = 'company_name';
    $input[] = 'company_name';
}*/

$query[] = 'firstname' . ' ' . 'lastname';
$query[] = 'lastname' . ' ' . 'firstname';


$clients = Client::search($request->all(), $query)->with('contacts')->get();

And with $request->get() I have the same, except it form field name

from eloquence.

My form as an example:

The name of my input fields are: company_name, firstname, lastname

And the eloquent relation:

Client hasMany Contact

clients: company_name
contacts: firstname, lastname

If several fields are filled I want to query with AND operator

For example:

• Find me the firstname and lastname
• Find me the company name and the firstname

from eloquence.

@Rtransat No, that's not what you'd use this feature for. Its purpose is to easily search items with relevance score (most likely full text), while your example is rather about explicit search. That is, you would explicitly apply the conditions to your query depending on the filled fields.

from eloquence.