Multiple orWhere() in whereHas() in Laravel 5

Question

Contact Model

class Contact extends Model
{
    public function Account()
    {
        return $this->belongsTo('app\Account');
    }
}

Account Model

class Account extends Model
{
    public function Contact()
    {
        return $this->hasMany('app\Contact');
    }
}

I want to get query of all Contacts that have account_name = 'test' or account_city ='test2'.

$query = Contact::query();
    $query->whereHas('Account', function ($q) {
        $q->orwhere('account_name' ,'=', 'test');
        $q->orwhere('account_city','=','test2');
    });
$query->get;

This query shows me all Contacts that have an Account but I want to get only Contacts that have account_name = 'test' or account_city ='test2'

Result of $query->tosql();

select * from `contacts` where exists (select * from `accounts` where (`contacts`.`account_id` = `accounts`.`id` or (`account_name` = ? or `account_city` = ?)) and `accounts`.`deleted_at` is null) and `contacts`.`deleted_at` is null

could you help to do [`$query->toSql()`](https://laravel.com/api/5.7/Illuminate/Database/Query/Builder.html#method_toSql) to see the actual generated sql query? — Bagus Tesa, Jan 15 '19 at 12:08

score 2 · Answer 1 · answered Jan 15 '19 at 12:22

2

 $query=Contact::query();
 $query  =  $query->whereHas('Account', function ($q)  {
       $q->orwhere('account_name',test');
       $q->orwhere('account_city','test2');
 });
 $query->get;

I think it will do the trick.

answered Jan 15 '19 at 12:22

sultania23

322
3
11

I know this but I create dynamic query and maybe I have `like` or '>' ,.... – paranoid Jan 15 '19 at 12:24
these can also be done.Go through Laravel Docs .These are very helpful – sultania23 Jan 15 '19 at 12:30

score 2 · Accepted Answer · edited Jan 15 '19 at 12:37

2

try this:

$query=Contact::query();
$query->whereHas('Account', function ($q) {
    $q->where(function($query) {
       $query->where('account_city','test2')->orWhere('account_name','test');
    });
});
$query->get();

edited Jan 15 '19 at 12:37

paranoid

6,799
19
49
86

answered Jan 15 '19 at 12:24

Jinal Somaiya

1,931
15
29

Multiple orWhere() in whereHas() in Laravel 5

2 Answers2