Sorting columns do not show personnalized background colors of row

Groqik

Hi,
In my use of Datatables, i added personnalized color for each row depending on the value of a colum in the row.
I use createdRow to do the change in backgroundColor
Everything is ok excepted when i sort rows using column headers, the sorting columns do not apply the color of rows and use only grey patterns defined in css.

Here is the code for the backgroundColor:
//--- Datatables : Personnalisation des couleurs une fois l'affichage réalisé
createdRow : function(row, data, index) {
//--- Mise en évidence des relances cloturées dérogées ou annulées
if ((data[24] == "X") || (data[24] == "C")
|| (data[24] == "V")) {
$(row).css('background-color', '#DDDDFF');
$(row).css('font-style', 'italic');
} else
//--- Mise en évidence des relances sans date de disponibilité
if (data[25] == "") {
$(row).css('background-color', '#FEFFBF');
} else
//--- Mise en évidence des relances en retard
if (parseInt(data[48]) <= 0) {
$(row).css('background-color', '#FEBFBF');
}

Any idea to solve my problem ? (i searched in the forum with no success)
Thx a lot
Groqik

kthorngren

Maybe you can put together an example so we can see a few rows of your data along with the code you are using. Without actually being able to see the code in action its difficult to visualize what is happening.
https://datatables.net/manual/tech-notes/10#How-to-provide-a-test-case

Kevin

Groqik

as requested
live.datatables.net/yojiyase/1/edit

Groqik

live.datatables.net/paqadacu/1/edit
I found this but i must investigate because on client side the rendering is very slow and with my application it takes more than 10 seconds with the same volume of data to display

kthorngren

Great.

client side the rendering is very slow

What is the Datatables data source?

If its Javascript or Ajax then you can use deferRender to help increase the speed.

Kevin

Groqik

It is Ajax.
But i checked time spent to retrieve data from server and it represents very small time compared to the rendering part on the client side.
I will look at this option