Michele Guarnaccia - 2015-12-16

Hi, how does the pivot grid work? it's not very clear how this kind of panel works. Same names are specified for different options.

By the way, here there's what i understood:

1) In panel definition a business component is required to list the pivot columns . This query is done before loading data. But what's the aim of the pivot flag in the panel columns definition?
2) Still in panel definition another business component is required to define the headers (note: in this version you can save the panel even without this setting, but frontend application will throw a Nullpointer Exception). This query is done after loading data once for each record returned from the main query.
3) "Aggregate column" flag must be checked for one and only one field.

Can you provide a complete and simple example?
Let begin from a small case: be the following columns retrieved by the main query:

ROW_NUM (PRIMARY KEY)
PRODUCT_CODE
COLOR_CODE
SIZE_CODE
QTY
UNIT_PRICE

And suppose that i want to display the total quantity of products grouped by product code and color code, but differentiated by size.

I would setup this configuration:
1) Pivot columns b.c. should contain: PRODUCT_CODE, COLOR_CODE
2) Header columns b.c. should containt: PRODUCT_CODE, COLOR_CODE
3) In Columns definition PRODUCT_CODE and COLOR_CODE should be checked as pivot column (why i have to specify this 3 times? sounds strange..)
4) In Columns defintion QTY should be checked as Aggregate column
5) In Columns defintion SIZE_CODE (and maybe UNIT_PRICE) should be checked as Identificator column

but this solution won't work.
Any help is appreciated.

Thank you