i’ve found a problem that has to do with a group table together with the editable mode and an aggregation.
When there is a groupTable that is editable and the column that is editable has additionally an aggregation defined, then the groups results are not displayed, only the total aggregation. Here’s an example of such a table:
<groupTable id="ordersTable" aggregatable="true" editable="true" height="100%" width="100%"> <actions> <action id="create"/> <action id="edit"/> <action id="remove"/> </actions> <columns> <group> <column id="orderDate"/> </group> <column id="netAmount" editable="true"> <aggregation type="SUM"/> </column> <column id="amount"> <aggregation type="SUM"/> </column> </columns> <rows datasource="ordersDs"/> <buttonsPanel> <button action="ordersTable.create"/> <button action="ordersTable.edit"/> <button action="ordersTable.remove"/> </buttonsPanel> </groupTable>
The netAmount column here is the problem. The sum of netAmount is not shown on a per orderDate basis, but only for all orders. The amount column instead correctly shows the different sums for each orderDate.
Attached you will find the example app as well as a screenshot that shows the problem.
I thought that it is just not possible to show aggregations on a editable column, but since the total sum of netAmount is correctly displayed and additionally even updated on a change of the values, i think it is just a bug.
So it would be great if you can take a look at this.