2. PHPRunner General questions
  3. Searching on Look Up Fields
This topic is locked

Searching on Look Up Fields

 		11/7/2007 4:59:21 PM
PHPRunner General questions
M
 MikeB941 author

PHPRunner 4.1 Build 320
Apologies in advance as I know I've seen a post about this...
If you have a field that's using a look up wizard, the ADVANCED SEARCH page handles this BEAUTIFULLY, presenting the various options available through the look up wizard, HOWEVER the SEARCH on the LIST PAGE doesn't appear to utilize the lookup wizard translation and searches against the "native" index or code values rather than the user friendly translations presented by the lookup wizard and advanced search (the user is typing in the LOOKUP values that appear on the list and these don't match the "native" index or codes of the field that the SEARCH on the LIST PAGE appears to be using).
The only work around I've found is to removed these lookup wizard fields from the SEARCH on the LIST PAGE and force the user to go to the ADVANCED SEARCH page.
Is there any way to get the SEARCH on the LIST page to search the LOOKUP values rather than the "native' index or code values?
Many thanks!
Take Care... Mike.
J
 		Jane 11/8/2007

Mike,
you can do the folowing:

  1. edit SQL query on the Edit SQL query tab.

    Here is a sample:
    select FieldName1,

    FieldName2,

    ...

    TableName.FieldNameN,

    LookupTableName.FieldNameDisplayField

    from TableName inner join LookupTableName

    on (TableName.FieldNameN=LookupTableName.FieldNameLinkField)


2. and check off FieldNameDisplayField on the search page only on the Choose fields tab.
J
 		jacekq 3/11/2008

PHPRunner 4.1 Build 320 and 4.2 Build 3.53
I also apologize but I could't find other posts on this topic and I have similar problem.

I've prepared special SQL query on the Edit SQL query tab and done all what Jane suggested.

Searching of user friendly values is not working in my project.

Not only AJAX suggest is not searching that field but also writing values and pushing search button gives no results on list view screen.
Any suggestions?
J
 		Jane 3/11/2008

Hi,
it's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.
J
 		jacekq 3/12/2008

Hi Jane,
I've already published my project on DEMO site and sent you an email with instruction.
Regards,

Jacek
L
 		lordkain2 8/13/2008

The search works, but ajax autosugest don't work.

SELECT

reportesdirectos.Id_Report,

reportesdirectos.Id_Dpto,

reportesdirectos.Id_Direct,

reportesdirectos.NoReport,

reportesdirectos.FechaReport,

reportesdirectos.Solucionado,

reportesdirectos.FechaSol,

reportesdirectos.NoReclam,

reportesdirectos.Notas,

oficinas.Nom_Of

FROM reportesdirectos

INNER JOIN oficinas ON reportesdirectos.Id_Dpto = oficinas.Id_Of


Can you help me please Jane?
J
 		Jane 8/14/2008

It's difficult to tell you what's happening without seeing actual files.
Please publish your project on Demo Account and send to support@xlinesoft.com a URL to your pages along with instructions on reproducing this error.

I'll find what's wrong with your project inspecting it at Demo account site.