Answers

• infiniteamit Posts: 2Questions: 1Answers: 0

  May 2016

  Hi,

  I think I gave up too soon probably. This forum is so rich that most of the answers are already out there and its just a matter of digging deep enough. I finally solved it looking at various other solutions out there. Here is the code

  $('#resultsTable').on( 'order.dt', function () {
          tableOrder = dataTable.order();
          dataTable.rows( '.danger' ).nodes().to$().removeClass( 'danger' );
          dataTable.rows( '.warning' ).nodes().to$().removeClass( 'warning' );
          dataTable.rows( '.success' ).nodes().to$().removeClass( 'success' );
          dataTable.rows().every(function ( rowIdx, tableLoop, rowLoop ) {
              var value = "";
              var data = this.data();
              if (tableOrder[0][0] == "1")
                  value = data.past24HoursCompliance;
              else if (tableOrder[0][0] == "2")
                  value = data.pastWeekCompliance;
              else
                  value = data.pastMonthCompliance;
              var rowClass = "";
              if (value <= parseFloat(redThreshold)) 
                  rowClass = "danger";
              else if (value > parseFloat(redThreshold) && value <= parseFloat(yellowThreshold) ) 
                  rowClass = "warning";
              else 
                  rowClass = "success";
              this.nodes().to$().addClass(rowClass);
          });
      } );