jQuery Grid Plugin - jqGrid - Topic: not exact grouping (case insensitive or grouping by intervals of values) http://www.trirand.com/blog/?page_id=393/feature-request/not-exact-grouping-case-insensitive-or-grouping-by-intervals-of-values Simple:Press Version 5.7.5.3 OlegK on not exact grouping (case insensitive or grouping by intervals of values) http://www.trirand.com/blog/?page_id=393/feature-request/not-exact-grouping-case-insensitive-or-grouping-by-intervals-of-values#p28722 Feature Request http://www.trirand.com/blog/?page_id=393/feature-request/not-exact-grouping-case-insensitive-or-grouping-by-intervals-of-values#p28722 Hello Tony

The pull request contains very simple changes in grouping module of jqGrid (one line was modified and tree lines was added), but it implement more advanced version of grouping.

The demo demonstrate the results which look like

Image Enlarger

Best regards
Oleg 

]]> Wed, 24 Apr 2013 14:13:58 +0300 OlegK on not exact grouping (case insensitive or grouping by intervals of values) http://www.trirand.com/blog/?page_id=393/feature-request/not-exact-grouping-case-insensitive-or-grouping-by-intervals-of-values#p28707 Feature Request http://www.trirand.com/blog/?page_id=393/feature-request/not-exact-grouping-case-insensitive-or-grouping-by-intervals-of-values#p28707 Hello Tony,

I answerd just now on the following question on the stackoverflow. The question was about case insensitive grouping. I remember before about close "not exact grouping" like grouping my year of by month and year instead of exact date values.

It seems to me that canging just one line of code allow to implement all the requirements. I suggest to change the line of code

if( typeof v !== "object" && grp.lastvalues[i] !== v ) {

to the following

if (typeof v !== "object" &&
        ($.isFunction(grp.isInTheSameGroup) ?
         !grp.isInTheSameGroup(grp.lastvalues[i], v) : grp.lastvalues[i] !== v)) { 

after that one could define groupingView with additional callback function isInTheSameGroup for example like the following

grouping: true,
groupingView: {
    ...
    groupField: ["name"], // the column by which we group
    isInTheSameGroup: function (x, y) {
        return String(x).toLowerCase() === String(y).toLowerCase();
    }
} 

The demo demonstrates the results. It displays the results like below

Image Enlarger

I don't tested grouping of multilevel, but I hope it should work too.

I think that implementation of the feature could be intresting for other users of jqGrid.

Bes regards
Oleg

]]> Mon, 22 Apr 2013 20:30:39 +0300