Hi All,
We are having problem with using calculations. Below are 2 scenarios:
1) Stored Calculations:
- Consider a calculation which updates based on date
- We are able to sort on this Calculated column. (Required to sort on this column)
- Now, if sorting is applied on foundset and calculation is updated then next sorting fails to work because records are edited. We cannot apply AutoSave as this is not intended.
2) Simple Calculations (Not stored):
- Foundset sorting is working fine as expected.
- But we cannot sort on this Calculated Column.
Suggestion:
If for Stored calculations, some Servoy internal save data call may update calculations ONLY. As this will resolve edited record issue and finally resolve sorting issue. Or sort functionality may be enabled on simple calculations as well.
Any help shall be highly appreciated.
Regards