How can I perform where queries correctly in laravel eloquent query builder

Question

Take a look at the following query:

    $testQuery = Customer::where('company_id', auth()->user()->company_id);

    $testQuery
        ->where('name', 'like', '%test%')
        ->orWhere('age', '>', 22);

    dd($testQuery->toSql());

this produces the following SQL query:

select * from customers where (company_id = ? and name like ? or age > ?) and customers.deleted_at is null

What I am after is something like this:

select * from customers where company_id = ? and (name like ? or age > ?) and customers.deleted_at is null

How can I achieve this? i.e. the first where condition of company_id = ? more important than there rest of the filters on name and age?

Right now, based on how the query builder is constructing the query, I am seeing results from other company_id than the one I've specified in my query.

What version of Laravel are you using?

Salim Djerbouh
– Salim Djerbouh

2019-09-21 23:56:56 +00:00
Commented Sep 21, 2019 at 23:56 — Salim Djerbouh
– Salim Djerbouh, Commented Sep 21, 2019 at 23:56
I am using laravel 6.

Latheesan
– Latheesan

2019-09-21 23:57:37 +00:00
Commented Sep 21, 2019 at 23:57 — Latheesan
– Latheesan, Commented Sep 21, 2019 at 23:57

Patrick.SE · Accepted Answer · 2019-09-21 23:58:43Z

4

I believe you want to use parameter grouping.

By using closures, you can tell the query builder what should be enclosed in parenthesis:

$testQuery = Customer::where('company_id', auth()->user()->company_id)
                     ->where(
                         function ($query) {
                           $query->where('name', 'like', '%test%')
                                 ->orWhere('age', '>', 22);
                      })->get();

answered Sep 21, 2019 at 23:58

Patrick.SE

4,5945 gold badges37 silver badges44 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How can I perform where queries correctly in laravel eloquent query builder

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related