group sorting in a grid

Suite and Optimus Suite 5
#1

My grid groups on a column that has a value of either 0 or 1. I need the group of rows with the 0 values to appear first in the grid, followed secondly by the group of rows with the 1 values. Sometimes, that is what I get; other times I get it the other way around.

I know how to sort the rows within the groups, but is there a way to force sorting of the groups themselves?

Thanks for your help.

#2

I have a similar problem. In my case, when I sort (ascending) on a column, I would like rows that contain “NULL” values displayed below the rows that contain valid data. Is there any way to accomplish this?

#3

Unfortunately the issue is not clear. sorting the groupped column you sort the groups at first.
Please, clarify your issue with sample of a code or screenshots.

#4

Still having trouble figuring out how to sort groups on my grid, so I am finally responding back to this. Attached is a screenshot of a simple grid. I want to sort the groups. In this case I need the “33” group to be before the “44” group.

Thanks.

group in order.png3008×2880 112 KB

#5

Well, as sometimes happens, merely asking the question leads to the answer. I had been placing grid.sortRows BEFORE grid.groupBy. That doesn’t work.

However, placing grid.sortRows AFTER grid.groupBy seems to work great.

Thanks.