Access to all returned data of dataTable query on server

[alr2413]

Summary of problem or feature request

First, thanks for this awesome package.
I want to calculate the sum of one columns of filtered data on my dataTable and send it to the client as an extra parameters. To make it more clear, assume that the selected column is price of an item and the extra parameter is the summation of price of all available items that is changed based on the requested search parameters.
As mentioned in dataTable docs, we can pass more extra parameters by the "with" method to the client. My problem is that how we can access all data on server.
Also note that this task can not be done in client-side because for a specific search parameters, only a portion of data are returned to the client based on the predefined pagination and the extra parameter (in my case "total price") is fixed for these search parameters.
Thanks.

System details

• Operating System: macOS High Sierra
• PHP Version: 7.1.10
• Laravel Version: 5.6.20
• Laravel-Datatables Version: 8.6.0

[alr2413]

I have found a trivial solution.
We can access to all data of dataTable by using $query->get() command in "dataTable" function and iterate over all data to calculate and extract our desired extra parameter. But I think this is not an efficient way if the data size becomes bigger.
I'm going to look for a better implementation way.

[yajra]

There is a less documented api that you can use to get the filtered query. See https://github.com/yajra/laravel-datatables/blob/8.0/CHANGELOG.md#added and #1068 for ref.

$dataTable = Datatables::of(App\User::query());
$response  = $dataTable->toJson();
$total = $dataTable-> getFilteredQuery()->sum('total');
// TODO: append queried total to JsonResponse.
return $response;

[alr2413]

Thanks a lot.

[yajra]

Hey, I just released a better way of doing this on #1758. Kindly give it a try. See also docs for some ref. Thanks!

EDIT
See #1759 instead. Thanks!