This topic is locked

Advanced Search Multiple Records

1/5/2008 9:36:54 PM
PHPRunner General questions
J
jackel66 author

OK i know this has been asked a few times and the answer always seems to be the same to enable multiple search on the advanced search page. But i dont know if im missing it somewhere or what but there is no option in the software for this and there is no How to in the help for this either. So on that note can someone please explain where i can find this multiple search and how to add it to a single field in the Advanced search????????

J
jackel66 author 1/8/2008

OK i know this has been asked a few times and the answer always seems to be the same to enable multiple search on the advanced search page. But i dont know if im missing it somewhere or what but there is no option in the software for this and there is no How to in the help for this either. So on that note can someone please explain where i can find this multiple search and how to add it to a single field in the Advanced search????????


so the admins, the users nobody knows?????? for a product that costs this much there sure is very little help for something that i thought would be a simple fix

J
Jane 1/9/2008

Hi,
you can do it editing SQL query on the Edit SQL query tab.

Here is a sample:

select field1,

field2,

field3,

field3 as field3_2,

...

from TableName


Then check off field3_2 on the advanced search page only on the Choose fields tab.

J
jackel66 author 1/9/2008

Hi,

you can do it editing SQL query on the Edit SQL query tab.

Here is a sample:
Then check off field3_2 on the advanced search page only on the Choose fields tab.


This is very helpfull but i think my question was mis-interpretted, i need to put many values in a single search block and have them all show on the results page if found
ex. Media
f10001

f10002

f10003 all values to search
result should show the entry in the DB for each of these. So three seperate records should be produced on the results page

J
Jane 1/11/2008

Hi,
unfortunately you can't search for more then one value in one search field.

PHPRunner do not support this search type.
You can add this search type to modify generated ..._search.php file manually.

However we don't have a ready to go solution for this.