NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: ianburgess on June 24, 2012, 05:24:02 AM

Title: Sorting a Browse by calculated field
Post by: ianburgess on June 24, 2012, 05:24:02 AM

I have a web browse which has a calculated field, using a local variable. The code to set the local variable is embedded Inside Browse Loop>1.Validate Record.

All works fine and the browse correctly displayes the local variable, EXCEPT that if one tries to sort by the contents of the local variable column by clicking the column heading, no records are displayed.

Can anyone suggest how to resolve this?

Many thanks.

Title: Re: Sorting a Browse by calculated field
Post by: Bruce on June 24, 2012, 11:40:25 PM

Hi Ian,

you can't sort by a calculated field - at least not directly.
The sort header translates into a prop:order statement for the View.
It's likely you would need to either hand-craft the prop:order (using the raw database fields) or turn off sorting on that column.

Cheers
Bruce