sort relation column

[mohanadjalal]

I got this error when I tried to sort a belongsTo relation :

relation method

  public function model()  
    {
        return $this->belongsTo(BrandModel::class, 'brand_model_id', 'id');
    }

inverse relation :

public function repaired()
    {
        return $this->hasOne(RepairedDevice::class);

    }

in index

<th class="text-center text-primary">@sortablelink('model.name', __('repaired.model')) </th>

[Maha-Mohammad]

can you show me your controller please ?

[mohanadjalal]

public function index(Request $request) { $rowPerPage = [5, 10, 15, 20, 25]; $searchText = $request->query('search'); $per_page = 25; $repairedQuery = RepairedDevice::query(); if ($searchText) { $repairedQuery->whereHas('customer', function ($query) { $query->where('customers.full_name', 'like', '%' . request('search') . '%'); })->orWhereHas('employee', function ($query) { $query->where('employees.first_name', 'like', '%' . request('search') . '%'); })->orWhere('imei', 'like', '%' . $searchText . '%') ->orWhereHas('model', function ($query) use ($searchText) { $query->where('brand_models.name', 'like', '%' . $searchText . '%')->orWhereHas('brand', function ($q) use ($searchText) { $q->where('brands.name', 'like', '%' . $searchText . '%'); });; }); }

if ($request->status) { 
    $repairedQuery->where('status' , $request->status);
}

$sortColumn = $request->query('sort', 'created_at');
$sortDirection = $request->query('direction', 'desc');

$repairedQuery->orderBy($sortColumn, $sortDirection);
if ($request->pagination)
    $per_page = $request->pagination;
$repairedDevices = $repairedQuery->sortable()->paginate($per_page)->withQueryString();
$count = $repairedDevices->count();
return view('repaired.index', compact('repairedDevices', 'count', 'rowPerPage'));

}

[Maha-Mohammad]

you can not sort two times try to remove this code $sortColumn = $request->query('sort', 'created_at'); $sortDirection = $request->query('direction', 'desc');

$repairedQuery->orderBy($sortColumn, $sortDirection);