Laravel Eloquent: How to get only certain columns from joined tables

by

Change your model to specify what columns you want selected:

public function user() {
  return $this->belongs_to('User')->select(array('id', 'username'));
}

And don’t forget to include the column you’re joining on.

More Related Contents:

  1. Laravel one to many relation with a one to one relation
  2. How to Create Multiple Where Clause Query Using Laravel Eloquent?
  3. How do I get the query builder to output its raw SQL query as a string?
  4. Get the Last Inserted Id Using Laravel Eloquent
  5. Bulk Insertion in Laravel using eloquent ORM
  6. Laravel Check If Related Model Exists
  7. Laravel, sync() – how to sync an array and also pass additional pivot fields?
  8. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  9. Laravel Model with Two Primary Keys update [duplicate]
  10. Laravel eager loading with limit
  11. Laravel OrderBy relationship count
  12. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  13. Laravel Eloquent: How to order results of related models?
  14. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  15. How to set a default attribute value for a Laravel / Eloquent model?
  16. Laravel $q->where() between dates
  17. Laravel – Database, Table and Column Naming Conventions?
  18. Order By before Group By using Eloquent (Laravel)
  19. How to Make Laravel Eloquent “IN” Query?
  20. How to Merge Two Eloquent Collections?
  21. Update without touching timestamps (Laravel)
  22. laravel collection to array
  23. Difference between Eloquent\Model::get() and all()
  24. Laravel Eloquent sort by relation table column
  25. Eloquent Parent-Child relationship on same model
  26. Laravel 4.1: How to paginate eloquent eager relationship?
  27. How can I query raw via Eloquent?
  28. A __construct on an Eloquent Laravel Model
  29. Eloquent groupBy make “SQLSTATE[42000]” with valid SQL query in Laravel 5.3
  30. Laravel Eloquent update just if changes have been made

Leave a Comment