AnsweredAssumed Answered

Capture and store the Sort Order

Question asked by david583 on Nov 6, 2010
Latest reply on Nov 9, 2010 by philmodjunk


Capture and store the Sort Order


FM Pro 10 & FM Pro 11, FM Server 11 on shared network. Solution built on FM Pro 10 ,Windows XP OS

Is it possible to Get(sort_order) or something similar? i.e. capture and store the sort order and wether it's ascending or descending.

I have many single field sort buttons as column headers as well as a sort button that opens the dialog for multi field sorts. It would be nice to display the current sort order on the list.

More importantly, it would be a great help if I could store an order and direction to come back to from future layouts. i.e. like a 'back arrow' sort of function.

Anyone had any ideas along these lines? I can do it fine from the single field buttons by setting a global text field value, but I can't figure out a way to store the direction. As for the multi field sort dialog, I have no idea.

Any help would be appreciated.