Group by multiple columns

[curiousgally]

I'm trying to implement a group by on multiple columns:

final ListGrid listGrid = new ListGrid() {
                @Override
                protected MenuItem[] getHeaderContextMenuItems(final Integer fieldNum) {
                    final MenuItem[] items = super.getHeaderContextMenuItems(fieldNum);
                    MenuItem customItem = new MenuItem("Group by Origin, Destination");
                    customItem.addClickHandler(new ClickHandler() {
                        public void onClick(MenuItemClickEvent event) {
                            ((ListGrid)event.getTarget()).groupBy("ORIG","DEST");
                        }
                    });
                    MenuItem[] newItems = new MenuItem[items.length + 1];
                    for (int i = 0; i < items.length; i++) {
                        MenuItem item = items[i];
                        newItems[i] = item;
                    }
                    newItems[items.length] = customItem;
                    return newItems;
                }
            };

I create the ORIG, DEST columns like this,

ListGridField origin = new ListGridField("ORIG", 100);
 ListGridField destination = new ListGridField("DEST", 100);

I have group summary and grid summary enabled on some other columns.

I don't get anything in the log and especially for LIST GRID component. Am I missing something here ?

thanks.

[curiousgally]

I just debugged it and found that event.getTarget returns the actual menu column header image. I'm trying to get reference to list grid from event object so that i can invoke groupby method on it.

thanks.

[curiousgally]

Any help on how to access the listgrid inside the onclick function, so that i can call a groupBy(...) method.

thanks.

[vinuriyer]

its so simple man!!!

u r inside the listgrid class

final ListGrid listGrid = new ListGrid() {
                @Override
                protected MenuItem[] getHeaderContextMenuItems(final Integer fieldNum) {
                    final MenuItem[] items = super.getHeaderContextMenuItems(fieldNum);
                    MenuItem customItem = new MenuItem("Group by Origin, Destination");
                    customItem.addClickHandler(new ClickHandler() {
                        public void onClick(MenuItemClickEvent event) {
                          [b]  groupBy("ORIG","DEST");[/b]
                        }
                    });
                    MenuItem[] newItems = new MenuItem[items.length + 1];
                    for (int i = 0; i < items.length; i++) {
                        MenuItem item = items[i];
                        newItems[i] = item;
                    }
                    newItems[items.length] = customItem;
                    return newItems;
                }
            };

u r already inside the listgrid reference object class.. so can directly call it :)
hop u may be new to java ,go thru basic concepts of java

[curiousgally]

Pheww, I had never instantiated a class like this (in-line) before. :) !!!

[vinuriyer]

hi :)

so u got the group by working ???

[vluison]

Hi,
it works fine but after grouping only the innermost total and Grand Total are computed and the outermost group are not computed.
How could I do to implement the calculation of the subtotals of the intermediate groups.

Thanks in advance.

[vinuriyer]

hi,

provide the code...i'll check it out

[curiousgally]

thanks, it's working..

Its straight forward.. :)