rowReorder does not update number in order column

rowReorder does not update number in order column

pgblcpgblc Posts: 1Questions: 1Answers: 0

I'm implementing datatables row reorder, and I'm able to reorder the rows just fine. The problem is that the 'order' column does not update to reflect the new row order for each row after the reorder. Below is my implementation. Everything is inside document.ready. Loaddata is called on document ready as well.

var routingtb;
        routingtb = $('#routingSegments').DataTable({
            "info": true,
            stateSave: true,
            "renderer": "bootstrap",
            "paging": false,
            "searching": false,
            "dom": '<Bfrtp>',
            select: true,
            rowReorder: true,           
            buttons: [
          
            ]
        });


 routingtb.on( 'row-reorder', function ( e, diff, edit ) {
            var result = 'Reorder started on row: '+edit.triggerRow.data()[1]+'<br>';
 
            for ( var i=0, ien=diff.length ; i<ien ; i++ ) {
                var rowData = routingtb.row( diff[i].node ).data();
 
                result += rowData[1]+' updated to be in position '+
                    diff[i].newData+' (was '+diff[i].oldData+')<br>';
            }
 
            console.log( 'Event result:<br>'+result );
        } );

  function Loaddata() {
            routingtb.rows().remove().draw();
            $.ajax({
                url: "@Url.Action("someaction", "somecontroller")",
                type: "POST",
                dataType: "json",
                data: { someparameter: @Model.someproperty},
                success: function (data) {
                    $.each(data, function (i, item) {
                        routingtb.row.add([
                                item.RoutingOrder,
                          ... more columns here
                             "<button type='button' class='btn btn-primary btn-sm removeRouting'><span class='glyphicon glyphicon-remove'></span></button>",
                            ""
                        ]).draw(false);
                    });
                
                }
            });
        }

This discussion has been closed.