Sort question

Classic Servoy
1

Hi,

I have a form (table view) with 2 fields where one field. Where one field is a normal database field and the other field is an aggregate field from a related table. I am unable to sort the aggregate field.

Would creating an unstored calculation field which basically gets the aggregate value from the related table and then sort the field by the unstored calculation field do the trick?

Any other way of doing it.

Regards
jdcunha

2

Hi jdcunha,

unfortunately an unstored calc won’t help you any further. Only ‘real’ columns can be searched/sorted so this would be at least a stored calc.

If you only need to display the table sorted ‘on show’ then you could create a dataset, sort the dataset on the ‘aggregate’ column and then load the dataset on the form. Records will be shown sorted.

If the user should be able to sort the table by clicking the table header you can consider creating a dataset - again :) - and then create the table form using the solution model and bind the dataset to it.

3

Hi Marc,

Thanks for replying. I will try the other options.

Regards
James Dcunha