2. PHPRunner General questions
  3. Default advance search value
This topic is locked

Default advance search value

 		1/30/2010 11:49:01 AM
PHPRunner General questions
U
 unp author

I want to add advanced search value('>=''2010-01-30 ') before the list page for afterwards to change it if necessary.

For example, I want to see a list from today onwards as standard, even in between, I need to see a list which is earlier than the date and must therefore be able to change it manually.
How can i do that?
J
 		Jane 2/2/2010

Hi,
to add custom WHERE statement on the list page use List page: Before SQL query event on the Eventstab.

Here is just a sample:

if (@$_REQUEST["a"]!="search" && @$_REQUEST["a"]!="advsearch" && @$_REQUEST["a"]!="showall")

{

$strWhereClause = whereAdd($strWhereClause,"FieldName>now()");

}