Using Distinct in Laravel Fluent
In my project I tried distinct()
and groupby()
too and both of them worked:
//Distinct version.Company_Customer_Product::where('Company_id', '=', $companyid)->distinct()->get(array('Customer_id'));//Goup by version.Company_Customer_Product::where('Company_id', '=', $companyid)->groupby('Customer_id')->get(array('Customer_id'));
According to this, distinct()
should work in your case too, just use it with get()
:
Return DB::table('volunteer') ->join('volunteer_volunteer_category', 'volunteer_volunteer_category.volunteer_id', '=', 'volunteer.id') ->select(array('*','volunteer.id AS link_id')) ->distinct() ->where('is_published', '=', 1) ->get(array('volunteer.id'));
Otherwise you don't need distinct()
when you use groupby()
so you could just use:
Return DB::table('volunteer') ->join('volunteer_volunteer_category', 'volunteer_volunteer_category.volunteer_id', '=', 'volunteer.id') ->select(array('*','volunteer.id AS link_id')) ->group_by('volunteer.id') ->where('is_published', '=', 1) ->get(array('volunteer.id'));