'Query More than one relationship from a model with() in Laravel

I need help to query a model base on its relationship:

I have a model called StoreStock, this model is related to a Product model, which has two model relationships, MasterList and Price.

I want to get all storeStock with two Product relationships.

I know i can do something like

StoreStock::all()->with('product.price')
->get()

With this, i can only pick either price or masterlist

phplaraveleloquent


Solution 1:[1]

Pass array of relationship to with method

 StoreStock::with(['product.price','product.masterlist']) ->get()

Solution 2:[2]

A little bit explanation here, many of the Laravel methods which support string, also support arrays. You can hover over the specific method and get the intellisense. In your case, it can be written like:

StoreStock::with(['product.price','product.masterlist'])->get()

If you want to run a specific action over any specific relation, you can also write it like this:

StoreStock::with(['product.price' => function(Builder $query) {
      // your action required with the query
},'product.masterlist']) ->get()

Hope someone finds this helpful

Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source
Solution 1 John Lobo
Solution 2 runtimeTerror

Related Questions