Laravel Eager loading select columns

Question

I get the following error when i try this error: Call to undefined method Illuminate\Database\Eloquent\Collection::select() Running this:

Portfolio::find($id)->transactions
        ->select('id','date','symbol','transaction_type','qty','amount');

but this works.

Portfolio::find($id)->transactions

I have a relationship in my portfolio model for

$this->hasMany('Transaction','portfolio_id');

So now to the real question. How can i select certain fields from the transactions table using eager loading? or do i need to do it using query builder

The Alpha · Accepted Answer · 2014-04-01 07:10:14Z

3

You may try this:

$portfolio = Portfolio::with(array('transactions' => function($q){
    $q->select(array('id','date','symbol','transaction_type','qty','amount'));
}))->whereId($id)->first();

This will return you Portfolio model along with related transactions and you may use following:

$portfolio->transactions->first()->amount

Also, you may loop them. But following will give you only related models:

Portfolio::find($id)->transactions()
         ->get(array('id','date','symbol','transaction_type','qty','amount'));

Check more on documentation about eager loading.

edited Apr 1, 2014 at 7:10

answered Apr 1, 2014 at 7:01

The Alpha

147k30 gold badges294 silver badges313 bronze badges

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

Comments

SUB0DH · Accepted Answer · 2014-04-01 05:06:48Z

0

You need to use get instead of select. If you want to select only some specific fields from the database, then you can pass an array to the get method, like in the following example:

Portfolio::find($id)->transactions()
        ->get(array('id','date','symbol','transaction_type','qty','amount'));

edited Apr 1, 2014 at 5:06

answered Mar 31, 2014 at 2:46

SUB0DH

5,2605 gold badges31 silver badges47 bronze badges

2 Comments

brandenwagner Over a year ago

so i tried that and got there error array_key_exists(): The first argument should be either a string or an integer

SUB0DH Over a year ago

Use transactions() instead of transactions as I have changed in my answer. If you have done everything else correctly, then that should solve your problem.

Collectives™ on Stack Overflow

Laravel Eager loading select columns

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related