Get Specific Columns Using “With()” Function in Laravel Eloquent

by

Well I found the solution. It can be done one by passing a closure function in with() as second index of array like

Post::query()
    ->with(['user' => function ($query) {
        $query->select('id', 'username');
    }])
    ->get()

It will only select id and username from other table. I hope this will help others.

Remember that the primary key (id in this case) needs to be the first param in the
$query->select() to actually retrieve the necessary results.*

More Related Contents:

  1. Get the Query Executed in Laravel 3/4
  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. Laravel Eloquent Query Using WHERE with OR AND OR?
  5. Add a custom attribute to a Laravel / Eloquent model on load?
  6. Creating and Update Laravel Eloquent
  7. How to sort a Laravel query builder result by multiple columns?
  8. How to Make Laravel Eloquent “IN” Query?
  9. Laravel Eloquent sort by relation table column
  10. Laravel Many to many self referencing table only works one way
  11. Laravel one to many relation with a one to one relation
  12. Get the Last Inserted Id Using Laravel Eloquent
  13. How to query between two dates using Laravel and Eloquent?
  14. Bulk Insertion in Laravel using eloquent ORM
  15. Laravel, sync() – how to sync an array and also pass additional pivot fields?
  16. How to alias a table in Laravel Eloquent queries (or using Query Builder)?
  17. Laravel Model with Two Primary Keys update [duplicate]
  18. Laravel eager loading with limit
  19. Laravel 5.2 – Use a String as a Custom Primary Key for Eloquent Table becomes 0
  20. Laravel Eloquent: How to order results of related models?
  21. Laravel 4: how to “order by” using Eloquent ORM [duplicate]
  22. How to alias the name of a column in Eloquent
  23. Laravel – Database, Table and Column Naming Conventions?
  24. How to Merge Two Eloquent Collections?
  25. Update without touching timestamps (Laravel)
  26. Eloquent Parent-Child relationship on same model
  27. Laravel 4.1: How to paginate eloquent eager relationship?
  28. Find or Create with Eloquent
  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