2. PHPRunner General questions
  3. Search not Working
This topic is locked

Search not Working

 		9/15/2009 06:37:03
PHPRunner General questions
M
 Mandy author

Hallo,

I have a table with several Foreign Keys and these, in turn are all "look-ups".

So whereas my actual table may contain columns (for example) of "keeper", "colour", the data might be "1", "5".

However, because I am looking-up the FK, the data displayed is not 1,5 but "Fred", "Blue".
I just tried using the search feature and if I search Fred or Blue, no results.

Is there a workaround, so the search returns results on the actual data displayed?
Tank you

Mandy
J
 		Jane 9/15/2009

Mandy,
please check this article:

http://www.xlinesoft.com/articles/search_sort_lookup_values.htm
M
 		Mandy author 9/15/2009



Mandy,
please check this article:

http://www.xlinesoft.com/articles/search_sort_lookup_values.htm


Hallo Jane.

I didn't explain myself well - the lookup works perfect but after the project is built IN THE BROWSER, the search does not "look-up", it only searches the integer values of the FK. So, although on my list page I see "fred" and "blue", when I search either of those values, none is returned.
J
 		Jane 9/16/2009

Hi,
to search lookup values you need to join main and lookup table on the Edit SQL query tab and then use joined fields in your search.