Level 50
Hey, this is a problem related with the mysql mode.
Go to config\database.php, mysql and set strict to false.
Nov 20, 2019
8
Level 51
how to use Group by in laravel
hi,
I am to retrieve data based on the day using groupBy. But I am getting an error like this
syntax error or access violation: 1055
what I have tried
public function index(){
$ids = Academic::active()->pluck('id');
if(Auth()->user()->getRoleNames() == '["Parent"]')
{
$id = Auth()->user()->Parents_id;
$parent = ParentName::find($id);
$students = $parent->students;
foreach($students as $stu)
{
$classid[] = $stu->class_id;
}
$timetables = DB::table('time_tables')->whereIn('academic_id', $ids)->whereIn('class', $classid)->groupBy('day')->get();
// $timetables = TimeTable::whereIn('academic_id', $ids)->whereIn('class', $classid)->get();
return response()->json($timetables);
}
Level 51
@manelgavalda No, it's not working. The query is correct?
Level 50
Yeah, it looks good to me. If you disable strict mode it should work. You can see more information here on how the strict mode works in laravel: https://mattstauffer.com/blog/strict-mode-and-other-mysql-customizations-in-laravel-5-2/
Level 51
@manelgavalda I have done strict to false but it is not working
Level 50
Whats the problem do you have now?
Level 51
@manelgavalda I am getting this error
SQLSTATE[42000]: Syntax error or access violation: 1055 'schoolmanagement.time_tables.id' isn't in GROUP BY (SQL: select * from `time_tables` where `academic_id` in (24) and `class` in (2, 4) group by `day`)"
Level 50
Mm, if the strict mode is not solving it, you can try to use groupBy after the get to use it as a collection method:
DB::table('time_tables')->whereIn('academic_id', $ids)->whereIn('class', $classid)->get()->groupBy('day');
Level 51
@manelgavalda thank you very much it's working now
1 like
Please or to participate in this conversation.