subquery in laravel - with()

Question

I'm making a query using the following line:

$items = $this->model->with('subCategory')->get();

But I want to put a query inside the with() method, because I just want to get the items from with() where the status is equal to 0.

How can I achieve this?

Maybe - http://stackoverflow.com/a/38371708/6569866 – Ilya Yaremchuk Jul 19 '16 at 00:36 — Ilya Yaremchuk, Jul 19 '16 at 00:36

score 2 · Answer 1 · answered Jul 19 '16 at 01:56

2

There is an "eager loading" in L5 documentation. Here

$items = $this->model->with(['subCategory' => function ($query) {
  $query->where('status', 0); }])->get();

answered Jul 19 '16 at 01:56

jsdecena

score 1 · Accepted Answer · answered Jul 19 '16 at 00:51

These are called eagarload constraints, you can achieve your result using a closure

For example

$items = $this->model->with(['subCategory'=>function($q){
    $q->whereId('5');
    //or any other valid query builder method.
}])->get();

Let me know how you get on.

2 Answers2