Laravel Grouping by Eloquent Relationship

laravel relation
yudijohn picture yudijohn · Apr 7, 2016 · Viewed 41.1k times · Source

How can I group by relation?

Example

Sales::with('product_detail.product')->groupBy('product_name')->get()

How can I get a result with eloquent code?

Answer

Imtiaz Pabel picture Imtiaz Pabel · Apr 7, 2016

You can specify a callback function for grouping your relation like this:

Sales::with(['product_detail.product' => function($query){
        $query->groupBy('product_name');
    }])->get();

Related questions

Laravel Eloquent Sum of relation's column

I've been working on a shoppingcart application and now I've come to the following issue.. There is a User, a Product and a Cart object. - The Cart table only contains the following columns: "id", "user_id", "product_id" and …

Read More
Laravel Search Relationship

I have two models which are related. I am trying to do a search in Products and only display the actual search results instead of ALL products of the category in which the product was found. I DO NOT want …

Read More
How Do I Get the Query Builder to Output Its Raw SQL Query as a String?

Given the following code: DB::table('users')->get(); I want to get the raw SQL query string that the database query builder above will generate. In this example, it would be SELECT * FROM users. How do I do …

Read More