Be part of JetBrains PHPverse 2026 on June 9 – a free online event bringing PHP devs worldwide together.
Hi, I'm trying to use 2 groupBy in a query, found this "addGrpupBy" in the QueryBuilder.php file, so i thought it might work, but it doesn't. Here is the query.
$sessions = Session::select(array('sessions.display_name', 'sites.name', 'programs.name')) ->join('programs', 'programs.session_id', '=', 'sessions.id') ->join('sites', 'programs.site_id', '=', 'sites.id') ->join('applications', 'applications.program_id', '=', 'programs.id') ->groupBy('sites.name') ->addGroupBy('programs.name') ->get();
The error that i get: Call to undefined method Illuminate\Database\Query\Builder::addGroupBy()
You may use just like here:
// given we have a query
$query->groupBy('sites.name', 'programs.name' );
Refered to docs here: https://laravel.com/docs/5.5/queries#ordering-grouping-limit-and-offset. From docs: You may pass multiple arguments to the groupBy method to group by multiple columns.
@vladshoob The thing is that i want to get 3 columns at my collection, and that returns only 2. I dont even know if it's posible xD
I beleive you don't need array in select statement. If sessions has display_name column then it suppose to show up. If it is not then it is hidden in model or not exists.
The thing is that i wasn't renaming the columns so it never returned me the 3 values...thx
Please or to participate in this conversation.