2. PHPRunner General questions
  3. Filtering Results in List Page
This topic is locked

Filtering Results in List Page

 		11/23/2007 5:56:59 AM
PHPRunner General questions
E
 Eerazor author

Ok this may be a really stupid question but I cannot, for the world figure out how to do this:
The List page contained Defined Data fields. How can I set this page up to list:
Field A contains

DataA

DataB
Field B contains

UserA

UserB
Field C contains

EntryA

EntryB
How can I set up the list page to show only:

FieldA = DataB AND FieldB = USERA
The rest of the entries hidden...
Would appriciate any help
Alexey admin 11/23/2007

Hi,
add WHERE clause to your query on the Edit SQL query tab in PHPRunner.

I.e.

select

...

from tablename

WHERE

FieldA = 'DataB' AND FieldB = 'USERA'
E
 		Eerazor author 11/23/2007

I feel silly now, the answer was staring in my face, thank you very much for your help