Laravel Controller Nested 'Where' Conditions

Question

I'm trying to get the query with the field 'Active = S', and have the result of that have 'BusinessName lilke $request->search' or 'Label like $request->search'

I think there must be a maybe nested way to do it

Thanks for your Help! Here is the code:

   $afiliates = DB::table('ad_afiliado')
        ->select('logo_url', 'NombreComercial', 'Destacado', 'id_afiliado', 'Clave','Activo')
        ->where('Activo','=', 'S')            
        ->where('NombreComercial','like', '%' . $request->search . '%')            
        ->where('Etiqueta', 'like', '%' . $request->search . '%')
        ->orderBy('CLAVE', $request->order)
        ->paginate(9);

This way I'm doing force to acomplish all "where's" and I want to acomplish always 'Activo = S' , and any of 'NombreComercial like' or 'Etiqueta like'

I'm using LARAVEL 7

Share some code, what you've tried so far?

ericmp
– ericmp

2022-10-20 14:43:23 +00:00
Commented Oct 20, 2022 at 14:43 — ericmp
– ericmp, Commented Oct 20, 2022 at 14:43

Cornel Raiu · Accepted Answer · 2022-10-20 21:08:55Z

1

I assume you are working on User model.

$users = User::query()
        ->where('active', 'S')
        ->where(function (\Illuminate\Database\Eloquent\Builder $query) use ($request) {
            $query->orWhere('businessName', 'like', "%{$request->search}%");
            $query->orWhere('label', 'like', "%{$request->search}%");
        })
        ->get();

Please make sure to update the model and column names with the relative names to your needs.

edited Oct 20, 2022 at 21:08

Cornel Raiu

3,0693 gold badges26 silver badges37 bronze badges

answered Oct 20, 2022 at 15:20

Shailesh Matariya

8405 silver badges14 bronze badges

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

4 Comments

Pepe F. Over a year ago

Sorry I didn't understand the 'query' part. I update my code. Thanks for your help!

Cornel Raiu Over a year ago

@PepeF. reading the docs is usually a very good place to start: laravel.com/docs/9.x/queries#logical-grouping

Pepe F. Over a year ago

Thanks @CornelRaiu I'll check that!

Pepe F. Over a year ago

@Shailesh Thanks re read your answer, and It works, I was missing the fieldnames mine's are in spanish, Thanks both!

Collectives™ on Stack Overflow

Laravel Controller Nested 'Where' Conditions

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related