I have a pivotTable on screen where Date field is in the column. I want the columns (Date) to be in ascending order and using the following query for loading the datasource.
select e from erp$ProductionPlanContinuousProdPivot e order by e.prodDate asc
But no change columns are displayed with sorting of first two digits of Date i.e. day only. Any suggestion would be appreciated.
According to the documentation, FS function needs to be used. There are some example given in the user guide but it will be more helpful if there is any guidance given on how to use the specific field(s) for sorting in this example “prodDate”.