Sortorder property for a field

Classic Servoy
1

Hello,

in table view I have the problem that I want to display an unstored calculation but still be able to sort by that column.

I think the easiest way would be a “Sortorder” property for a field. There, you can choose any field(combination) you want and if the user clicks on the column header, everything gets sorted by that sort order.

Is that possible?

Thanks
Patrick

2

If you make it a stored calculation - you can do it today.

3

I know, but my intention is not to store everything just to present it nicely, if you know what I mean…

4

Patrick,

Yeah, I get your meaning. However, if it’s just a field or two, that you use in that table view, then no big deal. The other benefit of storing a value is that you can find, sort and aggregate it as well.

5

can’t be done without storing as bob said.
And i don’t think it wont be possible in the further for just a foundset. Because if you want to sort the way you want you need the complete foundset in memory. And if the calculation uses all kinds of related and aggregate data. This will be a performance and memory killer.

6

it was just a thought :lol: