How can i display grouped row in the grid instead of all?

    I am getting all the rows having for each product details.   Suppose    Product   Month   sold    zone A                jan         10       VU B                jan          20       VU C                Jan           30        Vu Total number of sold products are : 60 on page   i want to display total number of sold product in VU Zone but righ now i am getting all.
1 answers

Hi Sunil,


If products and zones are different entities with an association between them, you can use an aggregate function to sum the sold items.

Base the datagrid on entity “Zone”, use xpath as datasource and add a column to the grid for the sold value.

Another option would be using OQL, which i personally find a bit exotic. See for example.

I hope this helps.