2. PHPRunner General questions
  3. Filter via dropdowns
This topic is locked

Filter via dropdowns

 		5/31/2009 9:41:23 PM
PHPRunner General questions
R
 rgfischerjr author

Looking for a way to use dropdowns to filter the list page - preferable two tiers of sorting. Any help greatly appreciated!
J
 		Jane 6/1/2009

Hi,
unfortunately there is no easy way to create dependent dropdowns on the list page.

Check this thread to create simple dropdown with search values:

http://www.asprunner.com/forums/index.php?showtopic=2301
R
 		rgfischerjr author 6/1/2009

Hi,

unfortunately there is no easy way to create dependent dropdowns on the list page.

Check this thread to create simple dropdown with search values:

http://www.asprunner.com/forums/index.php?showtopic=2301


Jane -
I've been all over that thread with no joy. I am unable to figure out how to get the dropdown to filter in my case - the list page is displaying records which include a lookup table - I need to filter by the id of the look up table, eg:
Table 1:

sopID, departmentID, sopDescription, sopFile, sopUpdate
table 2:

departmentID, departmentName
I need to display the departmentName in the select list and pass the departmentID to the filter (select * from Table1 where table1.departmentID = selected departmentID)
Thanks,

R
J
 		Jane 6/2/2009

Hi,
you can do it using custom event (Insert PHP code snippetoption on the Visual Editortab).

Here is a sample:

http://www.asprunner.com/forums/index.php?showtopic=2301