Case sensitive issue when multilevel grouping of 2 or more columns, using version 4.5.4

Question

I saw this link at Ignore case while grouping . So I implemented it and it works great but for some reasons, it doesn't work with certain data.

If I group by Make and Make, there, Chevrolet Tahoe show 3 seperate "Tahoe" rows. How do you allow multiple grouping for it to work?

Source code is found at https://dealerapp-test.bookitout.com/testcase1.html that include jqgridData's data value as it doesn't fit here due to exceeding 30000 characters error. There on that webpage, open up Chevrolet then look for "Tahoe".

Short version here without the jqgridData's value...

  





  
....

Oleg · Accepted Answer

You can fix the problem in very easy way. The property isInTheSameGroup is array like the the property groupField. So you can specify different rules how to group in different grouping level. If you want to makes case insensitive grouping on the both grouping levels you should change

groupingView: { 
    groupCollapse: true, 
    groupField: [ 'Make', 'Model' ],
    isInTheSameGroup: [
        function(x, y) { return String(x).toLowerCase() == String(y).toLowerCase(); }
    ]
}

to

groupingView: { 
    groupCollapse: true, 
    groupField: [ 'Make', 'Model' ],
    isInTheSameGroup: [
        function(x, y) { return String(x).toLowerCase() === String(y).toLowerCase(); },
        function(x, y) { return String(x).toLowerCase() === String(y).toLowerCase(); }
    ]
}

or to

groupingView: { 
    groupCollapse: true, 
    groupField: [ 'Make', 'Model' ],
    isInTheSameGroup: [
        caseInsensitiveCompare,
        caseInsensitiveCompare
    ]
}

where caseInsensitiveCompare are defined as

var caseInsensitiveCompare = function (x, y) {
        return String(x).toLowerCase() === String(y).toLowerCase();
    };

By the way the demo from the answer where I suggested the feature isInTheSameGroup originally uses two level grouping and isInTheSameGroup in the demo is array with two callback functions: one callback for one grouping level.

Case sensitive issue when multilevel grouping of 2 or more columns, using version 4.5.4

Answers (1)

Related Questions