2. PHPRunner General questions
  3. Sort problem on lookup field on list
This topic is locked

Sort problem on lookup field on list

 		6/8/2007 05:20:27
PHPRunner General questions
jxd author

Hello,
On the list page I have a column called Name for the customerId lookup to customer name.
When I click to sort that column to get it alphabetically sorted ascentding, PHPRunner sorts it always based on the customerId and never on the customer name. How can i fix this or is this a bug?
Need help here <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=5456&image=1&table=forumtopics' class='bbc_emoticon' alt=':rolleyes:' />
Alexey admin 6/8/2007

Hi,
you need to add a joined field to your SQL query and display it on List page.
Here is the article about doing that:

http://www.xlinesoft.com/articles/search_s...okup_values.htm

Skip the paragraph about GetFullFieldName function.
jxd author 6/8/2007

Hi,

you need to add a joined field to your SQL query and display it on List page.
Here is the article about doing that:

http://www.xlinesoft.com/articles/search_s...okup_values.htm

Skip the paragraph about GetFullFieldName function.


Again I applied your suggestion and issue is solved.
Many Thanks