Preserve sorting after updating a row (I know it been asked before around 2018)

Yogev

**# Hello all,#
**
First of all, I want to apologize that I am re-asking the same question which was already asked in the past. (https://datatables.net/forums/discussion/48237/preserve-sorting-after-updating-cell)

BUT, more than 3 years have passed since, So I hope this matter has a solution nowadays.

#My use-case:#
**
I have a Datatable that gets real-time updates from a server.
As an update comes to the connected clients the relevant row (and only it** - without refresh the entire table) is updating right in front of the client's eyes.
the code responsible for this magic is this:

**// Variables reference:
**
let tMorning = $('#datatable-morning').DataTable({});

// the crucial code
let row2manipulate = tMorning.row('#row_Id').data();
row2manipulate.rellavantColumn = 'some new data';
tMorning.row('#row_Id').data(row2manipulate).draw();

until here everything works like a charm !!! (thank you for that, datatables.net R&D team!)

**
My actual Issue:
**

after row.data().draw() the table is re-sorts itself.
and this is a functionality I wish to avoid.

needless to state, this is a bad UX for a client.

Thank you so much for any help/suggestion.

Cheers, Yogi.

colin

The same would apply as the thread you referenced. Because the data has changed, any draw() would cause the table to apply the current sorting. As Allan said, to keep that row in place you'll need a custom sorting plugin, something like absolute perhaps (example here).

Colin

Yogev

Thank you, Colin, I appreciate your answer. nevertheless, I think you are wrong mate. there is an option to preserve your sorting.

tMorning.row('#row_Id').data(row2manipulate).draw('page');

have a lovely day my friend.

colin

Gotcha, yep, that will work, I misread your message. Glad you got it sorted - well, not sorted I guess, but you know what I mean!

Colin

Yogev