i have looked into the PivotTable component and think that this is really a big feature that can be a game changer once again…
As i understand it, it groups and filters the data inline if i understand it correctly. So instead of changing the database query for filtering (and grouping) it fetches the whole table and does the filtering in memory of tomcat (is that right?).
So i tried to use the generic filter component in conjunction with the pivotTable. Unfortunately it doesn’t work out of the box. The filter needs a “applyTo” attribute which i set to the pivotTable. But it doesn’t seem to update the pivotTable.
The additional step that i took is to add a CollectionChangeListener and repaint the pivotTable like this:
collectionDs.addCollectionChangeListener(e -> pivotTable.repaint());
So this whole use case is for a non-editable pivotTable. So my question is here: can you support the repaint of the pivotTable through the usage of the “applyTo” attribute of the filter component?
In the editable PivotTable case, there are filter mechanisms baked into the pivotTable. Are these filters SQL filters or will they just not display the data on the UI but do the fetching of the whole dataset?