2. PHPRunner General questions
  3. [SOLVED]  How to: List page: Before Record Processed
This topic is locked
[SOLVED]

 How to: List page: Before Record Processed

 		6/30/2010 1:23:32 PM
PHPRunner General questions
S
 Seraph author

Hi,

I need process every row for select what I want to show and what instead not.
I tried to use (List page: before record processed) in this way:

if ($data["STATUS"] == "E")

return true;

else

return false;


But now I see some pages with 20 rows(default number) and other pages with minor of 20 rows...
How can I fix?
thank you very much
A
 		ann 7/1/2010

Hi,
to show only 'E' status you need to modify List page: Before SQL query event on the Events tab.

Here is just a sample:

$strWhereClause="STATUS='E'";
S
 		Seraph author 7/1/2010



Hi,
to show only 'E' status you need to modify List page: Before SQL query event on the Events tab.

Here is just a sample:

$strWhereClause="STATUS='E'";



Perfect! thanks.
I'd like to add this:



if($strWhereClause)

$strWhereClause.= " AND STATUS = 'E'";

else

$strWhereClause = "STATUS = 'E'";


In this way I can use the Search (otherwise I can't)
thank you!