Ordering & sorting column outside of database

[rickt25]

Thanks beforehandbeforehand i really like using your library 👍 , i would like to ask on how to order and sort an added column, and the column is not inside database.
Here in the code i added a column to check activity status ( indicator of user logged in or not with Cache ), to get the activity status i put it in my user model

// user model public function status(){ return Cache::has('is_online'.$this->id) ? 'online' : 'offline'; } and in my datatables service this is how i add the column

public function dataTable($query) { return datatables() ->eloquent($query) ->addColumn('status', function($user) { $status = $user->status(); // online or offline $text = ucwords($status); return "<div class=\"online-indicator strtolower($status)\"><span class=\"blink $status\"></span></div> $text"; }) ->rawColumns(['status']) ->orderColumn('status', function ($query, $order) { // still no luck here $query->orderBy('status', $order); }); // ->order(function ($query){ <-- i tried this // if(request()->has('status')){ // $query->orderBy('status'); // } // }); }

i have managed to show the data, but the error comes when i try sorting / ordering it.
i have tried several ways to order it from the documentation but i don't seem to know how to get the activity status
since it always tries to look for the data in sql query. meanwhile the activity status is not stored there.

do i really have to store it in database to make it work or is it possible?

edit : i have found out that addcolumn cant be sorted or ordered, ill be trying again

[rickt25]

#1790 (comment) and #2663 (comment) said its kinda impossible.