2. PHPRunner General questions
  3. how to default search on list page
This topic is locked

how to default search on list page

 		8/30/2006 9:27:09 AM
PHPRunner General questions
F
 frocco author

I want to show filtered records on the list page when first viewed.

The user can then change the default search.
How can I default my list to ticketClosed=0
Thanks
Frank
J
 		Jane 8/31/2006

Frank,
Check off No records on the first page option on the Edit SQL query tab.

Then open generated ..._list.php file, locate following code snippet:

if(!$action)

$strSQL = AddWhere($strSQL,"1=0");



and replace it with this one:

if(!$action)

$strSQL = AddWhere($strSQL,"`ticketClosed`=0");
F
 		frocco author 8/31/2006

Jane,
Thank you...
Frank

Frank,

Check off No records on the first page option on the Edit SQL query tab.

Then open generated ..._list.php file, locate following code snippet:
and replace it with this one: