Updating "Totals" column after databinding

[trigonoahParticipant]

I’m having an issue with the grid related to the databind method. My grid displays several date columns that contain floats, and the last column of the grid is a “Totals” column that adds up all the row entries for a given row. The grid contains a checkbox that is used to hide columns that are in the past. I would like the grid to dynamically update the “Totals” column when the checkbox is changed. So in the asserted state, the “Totals” column should only show the totals for future dates; when deasserted, the “Totals” column should show the total for future and past dates. I’m required to define a new source URL for a new data adapter to properly pass in the checkbox value to the backend code. Using the loadComplete: function (data) callback of the data adapter, I’m able to verify that the returned data array contains the proper totals based on the state of the checkbox. However, the “Totals” column does not seem to update properly. I’ve even tried manually updating the column using the #('#jqxgrid').jqxGrid('setcellvalue') method of the grid, but no luck. After loading the first time, the grid never properly updates the “Totals” column.

Weirdly enough, I’m able to set an individual “Totals” cell using the #('#jqxgrid').jqxGrid('setcellvalue') method in the grid’s $("#jqxgrid").on('cellendedit', function (event)) event.

Any advice on what I may be doing wrong?

[trigonoahParticipant]

For added clarification, I’m call the method #('#jqxgrid').jqxGrid('setcellvalue') in the loadcomplete: function (data) {} event of the data adapter, since that is where I can verify the data being returned by the server.

[trigonoahParticipant]

Nvm, figured out my issue.

[adminKeymaster]

Hi trigonoah,

If you wish, you can share details about that for the benefit of the other people in the Forum.

Thank you in advance.

[Author]

Posts