Laravel with([]) select only some columns of the relation

Question

Edit

This question is unique because it poses unique problems such as:

relations within the with components. (items.product.stockManagement).
A large amount of components, this causes the accepted answers of the linked question to not apply.

Suppose you have a large with() like the following:

$order = Order::with([
        'company',
        'complaints',
        'person',
        'items',
        'items.product',
        'items.product.stockManagement',
        'status', 
    ])->findOrFail($id);

How can I then select with all their relations but specific columns for some of them?

$order = Order::with([
        'company',   // select only id,name, size
        'complaints',  // select only id, name , body
        'person',     
        'items',  
        'items.product',  // select only id, name , price
        'items.product.stockManagement',
        'status',  // select only id
        'items.product.media',
        'items.product.mainProduct',
        'items.product.mainProduct.media'
    ])->findOrFail($id);

Does this answer your question? [Get Specific Columns Using “With()” Function in Laravel Eloquent](https://stackoverflow.com/questions/19852927/get-specific-columns-using-with-function-in-laravel-eloquent) — Douwe de Haan, Jun 25 '20 at 09:32
Could be that this is a duplicate, but the other question has a lot of not helpful answers, but maybe that post could be helpful as well. — Douwe de Haan, Jun 25 '20 at 09:33
@DouwedeHaan Thank you, the question you linked seems to be asking the same thing, but here the most voted awnser gives a clear and precicse awnser, unlike the most voted comments on the other question — Mister Verleg, Jun 25 '20 at 09:49

Douwe de Haan · Accepted Answer · 2020-06-25T11:05:00.907

Like this:

$order = Order::with([
    'company:id,name,size',
    'complaints:id,name,body',
    'person',     
    'items',  
    'items.product:id,name,price',
    'items.product.stockManagement',
    'status:id',
    'items.product.media',
    'items.product.mainProduct',
    'items.product.mainProduct.media'
])->findOrFail($id);

The documentation is very brief about the loading of specific columns (you even have to scroll down a bit to the heading that says "Eager Loading Specific Columns").

You may not always need every column from the relationships you are retrieving. For this reason, Eloquent allows you to specify which columns of the relationship you would like to retrieve:

$books = App\Book::with('author:id,name')->get();

Note:

When using this feature, you should always include the id column and any relevant foreign key columns in the list of columns you wish to retrieve.

Please describe your answer. – unclexo Jun 25 '20 at 10:59 — unclexo, Jun 25 '20 at 10:59
Yes it is. Thank you very much! – unclexo Jun 25 '20 at 11:54 — unclexo, Jun 25 '20 at 11:54

score 3 · Answer 2 · answered Jun 25 '20 at 09:36

3

You can also provide a callback for some more advanced relation querying.

Order::with([
    'company' => function ($q) {
         $q->select('id', 'name');
    }
])

answered Jun 25 '20 at 09:36

Dino Numić

1,414
2
9
17

score 2 · Answer 3 · edited May 31 '21 at 23:55

2

I faced the same problem. You need to specify the foreign id not id (primary key).

For example:

Data::with('other:id,name')->get();

It won't be working if you customize the foreign name. So, you need to add your foreign column name completely.

Data::with('other:foreign_id,name')->get();

And that will work!

edited May 31 '21 at 23:55

Showrin Barua

1,737
1
11
22

answered May 30 '21 at 03:28

Damhafafano

21
1

Thank you very much. That was my problem too. – Lehtis Sep 14 '22 at 12:10

score 0 · Answer 4 · answered Jun 25 '20 at 12:13

$order = Order::with(
['company' => function($query) {
    $query->select('id','name','size')
 }),
'complaints' => function($query) {
    $query->select('id','name','body')
 }),
'person',    
'items',  
'items.product'  => function($query) {
    $query->select('id','name','price')
 }), 'items.product.stockManagement','status'=> function($query) {
    $query->select('id')
 }),'items.product.media', 'items.product.mainProduct', 'items.product.mainProduct.media'])->findOrFail($id);

Laravel with([]) select only some columns of the relation

4 Answers4

Note: