How can append a row for "Total" of some columns which that row should be excluded in search and sort ?

[salmanulfaris]

Appending Aggregate row at last

I need to append a row which is the sum of numeric values of specific column. if i'm adding a row manually, it is included in sorting and searching (this also method doesn't work with pagination.)

is there any way to exclude specific row from searching and sorting ?

Code snippet of problem

• PHP Version 8.0.10
• Laravel Version 8.83.7
• Laravel-Datatables Version 9.19.1

Thank You !

[yajra]

You can use withQuery to calculate the filtered sum then use the json response to display the value every drawCallback.

[github-actions[bot]]

This issue is stale because it has been open for 30 days with no activity.

[github-actions[bot]]

This issue was closed because it has been inactive for 7 days since being marked as stale.