Radicore Forum: How To » column heading sorts

Home » RADICORE » How To » column heading sorts

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

column heading sorts [message #823]

Tue, 15 May 2007 15:34

interop
Messages: 45
Registered: October 2006

Member

For those columns which are foreign keys to a technical key is it possible to modify the orderby for column headings in a list view?

for example:
I have a person table which has a foreign key to a company table. The primary key of the company table is a technical key.

In the list view of the person table I am displaying the company name instead of the technical key (by setting its control to dropdown in the dictionary). Sorting on the company name column is confusing to the user because it's actually sorting on the numerical technical key.

Is it possible to change this behavior to sort on the company name?
Thanks

Report message to a moderator

Re: column heading sorts [message #824 is a reply to message #823]

Tue, 15 May 2007 19:43

AJM
Messages: 2397
Registered: April 2006
Location: Surrey, UK

Senior Member

If you have the control for the foreign key set to popup or dropdown the default behaviour is to display the description field instead of the id field, but to still sort on the id.

If you look in the XML output file you should see that both the id and description fields are available, so it is a simple matter to change the screen structure file so that it displays the description field instead of the id. In that way it will actually sort on the description field.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Re: column heading sorts [message #2033 is a reply to message #824]

Sun, 03 May 2009 11:50

AJM
Messages: 2397
Registered: April 2006
Location: Surrey, UK

Senior Member

This is now explained in FAQ80.

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

Previous Topic:	Format data in a message
Next Topic:	Unsetting Action Buttons

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Thu Nov 05 02:00:03 EST 2026

Total time taken to generate the page: 0.00649 seconds