Group on One Attribute Sort by Another.

PointsWell

New grouping mechanism is a massive improvement on what was previously a rudimentary option.

Is there a way to Group on a field but sort on a totally different attribute?

for example

Code Type
0    Giraffe
1    Ape
2    Zebra
3    Cat

If I group on field Code then I would ordinarily get the values in the group header i.e.
0
1
2
3

but I'd like to instead show the Type in the group header, but obviously if I group on name I'd get

Screen Shot 2021-05-26 at 08.17.13.png

Which is not the correct order.

Is there a way to do this? Yes. Thanks for your help Vlad.

PointsWell

Initialisation Script on query

config.dataSource.group[0].compare = function (a, b) {
   if (a.items.length == 0)
            return -1;
   if (b.items.length == 0)
            return 1;
   if (a.items[0].SortCode == b.items[0].SortCode)
            return 0;
   if (a.items[0].SortCode > b.items[0].SortCode)
            return 1;

return -1;
};

Produces this:
Screen Shot 2021-05-26 at 08.17.25.png

See attached model for it in use.

GroupSortSolution.bsv.zip

43.55kB

GroupSortSolution.bsv.zip

43.55kB