2. PHPRunner General questions
  3. Advanced Search, selecting more than one value for a field
This topic is locked

Advanced Search, selecting more than one value for a field

 		9/10/2007 7:34:04 AM
PHPRunner General questions
D
 daviesgh author

Hi,
I would like setup the following in an advanced search page. I have a field to search on, which gets it values/descriptions from a lookup table. I would like to display all the descriptions from the lookup table for this field on the advanced search page with a checkbox against each. I would like to have several checkboxes ticked by default. The user can tick any number of checkboxes, and then perform the search on the values selected. If data is changed in the lookup table, then the advanced search page should reflect this (i.e. it isn't always going to be 5 values).
Has anyone solved this?
Gordon
Sergey Kornilov admin 9/10/2007

I can recommend to use a multiple rows lookup wizard.

We don't yet have an option to present it as a set of checkboxes.
W
 		wwwguru 9/11/2007

I can recommend to use a multiple rows lookup wizard.

We don't yet have an option to present it as a set of checkboxes.


Sergay where would one find the multiple rows lookup wizard?
Thanks
Sergey Kornilov admin 9/11/2007

"Edit as" type "Lookup wizard". Set number of rows to any value greater than one.
D
 		daviesgh author 9/13/2007

Sergay ,
On an advanced search, I have the following fields: Area, Region and Country. They are all using the Lookup Wizard. I want both Region and Country to be dependent on Area. Since Build 305, this dependent lookup is now working for Region and Country.
However, if I change Area to use the multiple rows lookup wizard, the dependent lookups for Region and Country only look at the first value for Area selected if I select two or more values for Area.
Also, how should I set up defaults for the User in the Advanced Search Page? I am currently doing following code in the BeforeProcessSearch() event. Are there better ways?:
function BeforeProcessSearch()

{

global $strTableName;

$_SESSION[$strTableName."_search"]=2;

$_SESSION[$strTableName."_asearchfor"]["area_no"]="2";

}
Regards,
Gordon
Alexey admin 9/14/2007

Gordon,
PHPRunner can not filter dropdowns dependent on multiple selection box.

We'll think how can we handle this.
Yes, your code is an optimal way to assign default values on Advamced Search page.