Hi all,
We have an editable IG which can have lots of rows. This IG also has aggregations on some columns (sums), and is breaked by one column.
The thing is that there are some calculated columns (which are operations done in the IG query), that depends on some other columns; so when a column is edited, we want to refresh immediately the calculated columns. What we do now is a DA on change on any of editable columns, for automatically save, and refresh that specific row.
However, the subtotals do no refresh, so we force the refresh of the whole IG. This causes that the page in which the modification is made is lost, and it goes again to the first page.
So, my question here is double:
-
Is there any way to set the page for an IG (with Javascript)?
-
Is there any way to refresh the subtotals in a aggregation without having to refresh the whole data?
I made an example with a test app:
Thanks!