Home / Questions / 302027
Accepted
Javier
Asked: 2020-10-19 13:18:45 +0800 CST 2020-10-19 13:18:45 +0800 CST

Distinct not working in Laravel 5.8

  • 772

I try to get the rows but without duplicates, I try to filter the duplicates by the "date_payment" column.

$datos = DB::table('quincenas')->distinct('fecha_pago')->get();

return view('employees\reports\fortnights')->with('data',$data);

Also tried like this:

$datos = DB::table('quincenas')->distinct()->get();

return view('employees\reports\fortnights')->with('data',$data);

Result:

enter image description here

laravel

2 Answers

  1. From documentation 1 and I quote:

    The distinct method allows you to force the query to return distinct results:

    Which could be translated as:

    The method distinctallows you to force the query to return different results

    You should use the method select()to indicate which column to apply the distinct(), that is, the one you want to filter by different values:

    Example code:

    Modelo::select('fecha_pago')
    ->distinct()
    ->get();

    Or if you are going to do it through the query constructor it can be like this:

    $data = \DB::table('tuTabla')
  ->select('fecha_pago')
  ->distinct()
  ->get();

    As you can see in both cases (which I have already tested) you must use the method selectto pass the desired column as an argument and then chain the method that will bring different values.

    References

    • 1
  2. Best Answer
    $muestraAnio = Resolucion::orderBy('gestion', 'DESC')->distinct('gestion')->pluck('gestion');
    • 0