SlickGrid: how to scroll through each row and set a color based on a condition?

Question

I start with SlickGrid. I would like to know how to iterate over each row in the grid and set the back color of the color based on the condition (for example: if the age is from 20 to 40 years, the row will be blue, otherwise it will be red).

Answer 1

Assuming you are using Slick.Data.DataView, you can change the method getItemMetadatato dynamically add classes to the containing element of the string. I will write as if your instance Slick.Data.DataViewis called dataView, here you are:

dataView.getItemMetadata = metadata(dataView.getItemMetadata);

function metadata(old_metadata_provider) {
  return function(row) {
    var item = this.getItem(row);
    var ret  = (old_metadata_provider(row) || {});

    if (item) {
      ret.cssClasses = (ret.cssClasses || '');
      if (item.age >= 20 && item.age <= 40) {
        ret.cssClasses += ' blue';
      } else {
        ret.cssClasses += ' red';
      }
    }

    return ret;
  }
}

This will add an element class 'blue'or 'red'element to the row.

Answer 2

, .

{id: "delete", name: "Del", field: "del", formatter: Slick.Formatters.Delete, width: 15},

formatters slickgrid,

(function ($) {
// register namespace
$.extend(true, window, {
    "Slick": {
        "Formatters": {                
            "Delete": DeleteLink
        }
    }
});


function DeleteLink(row, cell, value, columnDef, dataContext) {
    //Logic to present whatever you want based on the cell data
    return "<a href=\"javascript:removeId('contact', '" + dataContext.folderId + "', '" + dataContext.id + "')\"><img width=\"16\" height=\"16\" border=\"0\" src=\"/images/delete.png\"/></a>";
}

})(jQuery);