KoolReport's Forum

Official Support Area, Q&As, Discussions, Suggestions and Bug reports.
Forum's Guidelines

Datagrid - serverside - formatValue #2476

Open Coby opened this topic on on Dec 3, 2021 - 4 comments

Coby commented on Dec 3, 2021

Hello formatValue is not working when you are using datagrid / server side => true works well, when server side is false any suggestion ? database and very large and using server side => false crashes on very large memory allocation Thanks Coby

Sebastian Morales commented on Dec 3, 2021

We will change this behavior of server side processing's not applying "formatValue" like client side processing in the next version of DataTables widget. Meanwhile you could use the following fix to see if it solves the problem for you:

1 . Open the file koolreport/datagrid/DataTables.tpl.php and replace this line:

        'data' => $ds->data()

with this one:

        'data' => $this->dataRows
Coby commented on Dec 3, 2021

thanks for the prompt reply! your solution works

follow up questions on datagrid: 1 - looks like when you are using UNION on the sql, pagination does not work

2 - when you are using the option plugins, the drop down of records per page does show up

Thanks

Coby commented on Dec 3, 2021

also, how do you set the file name when exporting data using the plugins thanks

Sebastian Morales commented on Dec 6, 2021

Hi, that's great to see the solution for "formatValue" work. For following up questions, would you mind opening a separate topics for each question so that we and other users can better follow or search them later. Tks,

Build Your Excellent Data Report

Let KoolReport help you to make great reports. It's free & open-source released under MIT license.

Download KoolReport View demo
None yet

None