Sorting columns do not show personnalized background colors of row

Sorting columns do not show personnalized background colors of row

GroqikGroqik Posts: 4Questions: 1Answers: 0
edited July 2018 in Free community support

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

This question has an accepted answers - jump to answer

Answers

  • kthorngrenkthorngren Posts: 21,330Questions: 26Answers: 4,951

    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

  • GroqikGroqik Posts: 4Questions: 1Answers: 0
  • GroqikGroqik Posts: 4Questions: 1Answers: 0

    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

  • kthorngrenkthorngren Posts: 21,330Questions: 26Answers: 4,951
    Answer ✓

    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

  • GroqikGroqik Posts: 4Questions: 1Answers: 0

    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

This discussion has been closed.