jQuery Grid Plugin - jqGrid - Topic: Custom sort function on column

lotjuh on Custom sort function on column

Wed, 21 Oct 2009 15:56:57 +0300

Yeah I thought about that solution myself as well, but I found it rather ugly since the user can see the '0' and '1' as soon as they do a text select on the cell.

And I do have other places where I'd like to use a custom sort function like columns with ip addresses I use in a different project.

dsh0105 on Custom sort function on column

Wed, 21 Oct 2009 14:17:52 +0300

I don't have an exact answer for you.. but I can suggest a quick work around: use your custom formater to font-color of the value to the same as the background then let the normal column sort do it's magic. I'm sure someone with more JQgrid experince can offer a JQgrid solution though.

lotjuh on Custom sort function on column

Wed, 21 Oct 2009 05:36:26 +0300

Hi everyone,

I've been searching for a while, but I can't find anything about how to add a custom sort function to a column. I'm not even sure if it's possible in jqgrid.

As you can see at http://www.gebroederslaan.nl/b.....chema.html I have cells that just show a color. I've accomplished this by using a custom formatter for these columns:

function colorFormatter(cellvalue, options, rowObject) {
     if(cellvalue == 1) {
         return '<div class=”ui-state-highlight”> </div>';
     }
     else {
   return '';
     }
}

But now I want to be able to sort on these columns as well. Since there's no real value in it, jqgrid won't sort it. So I want to use a custom sort function which checks if there's an html element with the class “ui-state-highlight” in it or not to handle the sorts.

Does anyone know how to do this?

Kind regards Lotte-Sara Laan