2. PHPRunner General questions
  3. List Page Filteration
This topic is locked

List Page Filteration

 		12/14/2007 6:08:07 AM
PHPRunner General questions
B
 barbary author

Dears,

I want to make the list page displays only records with current status "1"

I have a field "Current" that displays "1" or "0"

Also I have a field that displays "From" time, I want also records listed only when from is < now()

how can I do this
BR,

Mahmoud
J
 		Jane 12/14/2007

Mahmoud,
to filter records on the list page edit your SQL query on the Edit SQL query tab in the PHPRunner.

Here is a sample:

select field1,

field2,

...

fieldN

from TableName

where Current=1 and From<now()
B
 		barbary author 12/14/2007

Thanks for your fast reply

But I would like to use an event "After List Page Processed"

I used it before, but I can't use it now

I want to list records normally in the list page, but only records that "Current" field is 1 and "Fom" is < now()
BR
B
 		barbary author 12/14/2007

Dears,

anyone can help ??
mic'',) 12/14/2007

Hi,
Try to use SQL Editor and use recenty instruction by Jane you can do it in the list page.
SELECT field1,

`field2`,

...

`fieldN`

from TableName

WHERE `current` = 1 AND FROM < now()
Sergey Kornilov admin 12/15/2007

Mahmoud,
there is no "After List Page Processed" event.
What is wrong with suggestion above? You can add a WHERE clause to SQL Query.