laravel query builder (GROUP CONCAT) error

Question

I have a collection of user skills but i need is to get only skills as an array i tried this

$builder->where('job_id', $value)
->join('users', 'job_applicants.user_id', '=', 'users.id')
->join('user_skills', 'users.id', '=', 'user_skills.user_id', function ($join){
    $join->selectRaw("GROUP_CONCAT(user_skills.skill, ', ')");
})
->groupBy('job_applicants.job_id')
->get();

The exception message : Object of class Closure could not be converted to string

Devon Bessemer · Accepted Answer · 2018-11-15 13:01:34Z

2

The join closure should be the first and only argument after the table name.

->join('user_skills', function ($join) {
    $join->on('users.id', '=', 'user_skills.user_id')
         ->selectRaw("GROUP_CONCAT(user_skills.skill, ', ')");
});

However, a selectRaw inside the join closure doesn't make a whole lot of sense. Logically, this isn't where you select data. You've joined the table, your select statement belongs in the main query, it doesn't belong contained within the join, like so:

$builder->selectRaw("job_applicants.*, GROUP_CONCAT(user_skills.skill, ', ')")
    ->where('job_id', $value)
    ->join('users', 'job_applicants.user_id', '=', 'users.id')
    ->join('user_skills', 'users.id', '=', 'user_skills.user_id')
    ->groupBy('job_applicants.job_id')
    ->get();

edited Nov 15, 2018 at 13:01

answered Nov 15, 2018 at 12:35

Devon Bessemer

35.6k10 gold badges77 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Ahmad Elkenany Over a year ago

$builder->selectRaw("job_applicants.*, GROUP_CONCAT(user_skills.skill, ', ') as Skills") ->where('job_id', $value) ->join('users', 'job_applicants.user_id', '=', 'users.id') ->join('user_skills', 'users.id', '=', 'user_skills.user_id') ->groupBy('job_applicants.job_id');

Collectives™ on Stack Overflow

laravel query builder (GROUP CONCAT) error

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related