I have a PivotTable, it works fine without a parameter and now I want to let user select date range and refresh the pivot table.
Here is my core in screen for datasource:
select e from erp$ProductionPlanContinuousProdPivot e where (e.prodDate between :custom$datefrom and :custom$dateto) order by e.prodDate asc
in controller
@Inject
private DateField dateFrom;
@Inject
private DateField dateTo;
to refresh
productionPlanContinuousProdPivotsDs.refresh(ParamsMap.of("datefrom", dateFrom.getValue(), "dateto", dateFrom.getValue())); pivotTable.repaint();
Thanks for any help!