How to use sortable inside of a query done inside controller.

[JYvman]

Right now, I use a query to display data into a table, so I dont have a model for it. How can I use sortable in this case?

$trainings = Training::sortable()->paginate(8);

    $managers = DB::table('trainingdata')
        ->select('staffName','staff_id','trainer','programTitle','trainingDate','hours','reportingTo')
        ->where('staffName', $username)
        ->orWhere('reportingTo', $username)
        ->get();

    $employees = Training::sortable()
        ->where('staffName', $username)
        ->paginate(8);

$managers is using a query, how do I solve this?

[dhanyn10]

sorry, are you want to use sortable and search together?