Laravel When Condition on a column

Question

I have a ModelA with columns: name, last_name, email

I want ModelA with the name Test to add an extra where on email

what I tried is the following

$model_a_res = A::when(
function($query){
    return $query->where('name','Test');
},
function ($query) { 
    $query->where('email', 'NOT LIKE', '%@test%');})
->first();

I want this second where to only run on A with column name = Test however, this is not working.

I tried it with user name Mike and his email [email protected] and he didn't appear in the result.

some data

id name email

1 Test [email protected] 
2 Test [email protected]
3 Mike [email protected]
4 Mike [email protected]

both 3 and 4 should be in the results 1 and 2 since they have name = Test will have another query which will check if he does have @test in his email if he does he will not be returned returned Rows are 2, 3, 4

Add extra querying, extra where condition if this row has the column name = Test — Zein
– Zein, Commented Mar 8, 2024 at 10:28
when() only executes the closure if the first argument is true. By that logic, your first parameter is not returning true. But we would need more information. — geertjanknapen
– geertjanknapen, Commented Mar 8, 2024 at 10:49

Abdulla Nilam · Accepted Answer · 2024-03-08 10:51:00Z

3

You can't use when() for this.

$model_a_res = A::where(function ($query) {
    $query->where('name', '!=', 'Test')
          ->orWhere(function ($query) {
              $query->where('name', '=', 'Test')
                    ->where('email', 'NOT LIKE', '%@test%');
          });
})->get();

Outputs

1 Test [email protected]  -  will skipp
2 Test [email protected] - added
3 Mike [email protected]  - added
4 Mike [email protected]  - added

answered Mar 8, 2024 at 10:51

Abdulla Nilam

39.7k18 gold badges85 silver badges115 bronze badges

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

Collectives™ on Stack Overflow

Laravel When Condition on a column

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