Laravel Eloquent - Select Certain Columns Combine with Eager Loading

Question

How to select certain columns on parents table while querying with eager loading?

$accounts = \App\Account::with('status')->get();

Return

[{"id":1,"username":"kuhn.desiree","email":"[email protected]","last_login":"2009-04-02 23:21:20","created_at":"2017-07-15 19:07:03","updated_at":"2017-07-15 19:07:03","status_id":13,"status":{"id":13,"name":"ab","desc":"Quos quas.","created_at":"2017-07-15 19:07:01","updated_at":"2017-07-15 19:07:01"}}]

I only want username and email on Account table.

Chandra Kumar · Accepted Answer · 2017-08-03 09:24:59Z

1

Try to use this code:

$accounts = \App\Account::with(['status' => function($q)
            {
                $q->select('username', 'email');
            }])->get();

answered Aug 3, 2017 at 9:24

Chandra Kumar

4,2131 gold badge19 silver badges26 bronze badges

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

1 Comment

Yosua Lijanto Binar Over a year ago

as far as I know this code only filter child table.

Mohammad Fanni · Accepted Answer · 2017-08-03 09:38:20Z

0

one way is using select() method

$accounts = \App\Account::with('status')->select('username', 'email','status_id')->get();

If you would like to retrieve a Collection containing the values of a single column, you may use the pluck method.:

accounts = \App\Account::with('status')->pluck('username', 'email');

edited Aug 3, 2017 at 9:38

answered Aug 3, 2017 at 9:28

Mohammad Fanni

4,2033 gold badges31 silver badges55 bronze badges

4 Comments

Yosua Lijanto Binar Over a year ago

I have tried but unfortunately it returns null status. {"username":"kuhn.desiree","email":"quentin.gleason@example.‌net","status":null}

Mohammad Fanni Over a year ago

@YosuaLijantoBinar check this select('username', 'email','status')

Yosua Lijanto Binar Over a year ago

nice, please update your answer with $accounts = \App\Account::with('status')->select('username', 'email', 'status_id')->get(); and I will accept.

Yosua Lijanto Binar Over a year ago

dude it needs status_id not status

DrRoach · Accepted Answer · 2017-08-03 09:24:23Z

0

You want to add a select call:

$accounts = \App\Account::with('status')->select('username', 'email')->get();

answered Aug 3, 2017 at 9:24

DrRoach

1,3569 silver badges16 bronze badges

1 Comment

Yosua Lijanto Binar Over a year ago

I have tried but unfortunately it returns null status. {"username":"kuhn.desiree","email":"[email protected]","status":null}

Collectives™ on Stack Overflow

Laravel Eloquent - Select Certain Columns Combine with Eager Loading

3 Answers 3

1 Comment

4 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

4 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related