Laravel 5.5 can't get selected column data using belongsTo

I have 2 models (User & UsersDetails) in relation with Eloquent Laravel.

User

UsersDetails

Model "User" Realation With 'SelDetails'

public function SelDetails
return $this->belongsTo('AppUsersDetails', 'users_id');



I want to get only two column 'created_by_id', 'created_by_name' from SelDetails

UserController

$users = User::with(['SelDetails' => function($query)
$query->select(['created_by_id', 'created_by_name']);
])
->where('is_active', '=', 0)
->orderBy('id', 'desc')
->get();


I am getting data from User but getting blank in SelDetails

User

SelDetails

[relations:protected] => Array
(
[SelDetails] =>
)


Please correct me.

$query->select(['user_id', 'created_by_id', 'created_by_name']);

public function SelDetails return $this->belongsTo('AppUsersDetails', 'users_id', 'created_by_id');

3 Answers
3

guys thanks for your precious response on this issue. i got the solution via following way.

changes in "User" model Relation With 'SelDetails'

public function SelDetails
#return $this->belongsTo('AppUsersDetails', 'users_id');// the old one
return $this->hasOne('AppUsersDetails', 'users_id');



changes in "UserController"

$users = User::with('SelDetails')->where('is_active', '=', 0)->orderBy('id', 'desc')->get();


that's the changes that I have made and got the result

Thanks

I might be wrong but it might be the array in select, try

$query->select('created_by_id', 'created_by_name');


Have you tried something like

$users = AppBook::with('author:id,name')->get(); from the documentation?
In your case it should looks like:

$users = AppBook::with('author:id,name')->get();

User::with('SelDetails:created_by_id,created_by_name')
->where('is_active', '=', 0)
->orderBy('id', 'desc')
->get();


with() method can take string (or array filled by strings) eg. relationName:column1,column2.

with()

relationName:column1,column2

Thanks for contributing an answer to Stack Overflow!

But avoid …

To learn more, see our tips on writing great answers.

Required, but never shown

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service, privacy policy and cookie policy