Searching from model and related model in laravel5

Question

I want to keyword search from a table and its all related table using Elequent in Laravel5. My controller is

 $clients = Client::with('contacts', 'paymentTerm', 'addressInfo');
    if ($q = Request::input("q")) {
        $clients->where("clients.name", 'LIKE', "%$q%");
        $clients->where("address_info.email", 'LIKE', "%$q%");//This is not working,I want to search from both client and client address_info
    }
    return $clients->paginate(10);

Client Model ,

 public function addressInfo() {
    return $this->hasOne('App\Model\ClientAddressInfo');
}

Client Address info,

public function client() {
        return $this->belongsTo('App\Model\Client');
    }

how can I apply keyword search here?

lukasgeiter · Accepted Answer · 2015-03-08 15:19:32Z

2

You can use whereHas to filter by a related model:

$clients->whereHas('addressInfo', function($query) use ($q){
    $query->where("email", 'LIKE', "%$q%");
});

answered Mar 8, 2015 at 15:19

lukasgeiter

154k29 gold badges349 silver badges280 bronze badges

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

6 Comments

gsk Over a year ago

Thank you for answer and it is working,but the problem is two conditions are joining here with "and", how it make "or" ?

lukasgeiter Over a year ago

Simply use orWhereHas instead of whereHas (it works the same as with two "normal" wheres)

gsk Over a year ago

How can i sort from related model $clients->orderBy('addressInfo.email');?

lukasgeiter Over a year ago

Unfortunately that's just possible if you use a join. See this

gsk Over a year ago

So I need to change Elequent method to db method ?

|

Collectives™ on Stack Overflow

Searching from model and related model in laravel5

1 Answer 1

6 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related