Forums

the sort functionality is not working for me after I add a new record or alter the data of an existing record to the data table. when altering i am using "updateCell" function.

it does however begin to work as expected once i click another column to sort then return to original column the sort works fine, just not the very first attempt. it's as if the data isn't being registered until i try to sort at least 2 columns, but i would like the initial sort to work.

thanks in advance.

I meant to say that sorting is not working properly until i sort another column first.

for example i am putting a number in a column which is 0 by default, when i change 0 to 3 and hit save the number changes in the cell but if i then go and click the column heading to sort it, the row stays with the 0's and doesn't move into the vicinity of the other "3's".

if however, i go sort another column and then come back and sort the number column, it behaves as expected; moving the newly assigned "3" row in with the other "3's".

perhaps i need to call some type of reload function after "updateCell" so the altered data is properly recognized by the sort engine?

thanks

thanks very much that fixed part of my issue.

i do still however have an issue when adding a completely new row (rather than just altering a cell in an existing row).

after adding a new row, the sort does not work unless i sort at least 2 columns.

thanks

Hi Satyam,


I am facing the same problem with Sort not working initially on newly added record or when the DataTable record is updated.

My DataTable has a DropDownCellEditor control and some other HTML controls(like html TextBox created dynamically using Column formatters).

Your solution to make the sortedBy = null in 'editorSaveEvent' fixed partially.

It works fine for DropDownCellEditor column If I try to sort the same column after adding/update.

It doesn't work the same for other columns as those columns doesn't have any YUI editors like TextBoxCellEditor. Those columns has HTML controls like TextBox.


And I think the 'editorSaveEvent' will fire only for YUI cell editors and not for custom editors like HTML text box.

Please tell me how to handle the sort the same column after add/update if the DataTable has some custom HTML controls.

Thanks

Then which event, can I put the code 'sortedBy = null' so that the DataTable will know that the column(which has html input control) needs to be sorted again once we sort the same column after add/update?