This topic is locked

Sorting Problem

5/9/2013 1:10:12 PM
PHPRunner General questions
S
stiven author

Hello,
I have a field "coordinator" it's and INT type and its set up as a lookup wizard, the link field is an INT type and the display field is the full_name a VARCHAR type, when I click on the header coordinator its sorting by the link field which is an INT type so its sorted by the number but it is not sorted in alphabetical order on the display field which is what I need. I hope this makes sense.
Does anyone know if there is any way to fix this?
Thanks for your help.

C
cgphp 5/10/2013

Lookup wizard has the "Order by" option. Check it http://xlinesoft.com/phprunner/docs/lookup_wizard.htm

W
wpl 5/10/2013



Hello,
I have a field "coordinator" it's and INT type and its set up as a lookup wizard, the link field is an INT type and the display field is the full_name a VARCHAR type, when I click on the header coordinator its sorting by the link field which is an INT type so its sorted by the number but it is not sorted in alphabetical order on the display field which is what I need. I hope this makes sense.
Does anyone know if there is any way to fix this?
Thanks for your help.


Stivens,
I think this might be what you are after:
http://xlinesoft.com/articles/search_sort_lookup_values.htm

S
stiven author 5/10/2013



Stivens,
I think this might be what you are after:
http://xlinesoft.com/articles/search_sort_lookup_values.htm


Thanks for the suggestion, unfortunately that is not what I'm looking for. I already have the set up like that but it doesn't work, it only sorts on the dropdown box I want it to sort on the list page. Now that I looked at that article I can't search on one of my lookup wizard fields either.

W
wpl 5/11/2013



Thanks for the suggestion, unfortunately that is not what I'm looking for. I already have the set up like that but it doesn't work, it only sorts on the dropdown box I want it to sort on the list page. Now that I looked at that article I can't search on one of my lookup wizard fields either.


Hmmm - I'm doing that all the time and it works fine for me (sorting and searching).