2. PHPRunner General questions
  3. Limiting records displayed on List Page
This topic is locked

Limiting records displayed on List Page

 		10/9/2008 9:34:13 AM
PHPRunner General questions
K
 kplunkert author

Is it possible to limit the records that are displayed on the list page to records created today without limiting the entire app to today's record?
In other words -
Going to the list page it displays just the records displayed today.
Running reports or queries uses all the records in the database.
Thanks
KJ Plunkert
T
 		thesofa 10/9/2008

make a custom view of just the records you want to show on the list page and base the list page on that, then use the tables for all the other pages
Sergey Kornilov admin 10/9/2008

Karl,
you can add the following WHERE clause to SQL query on SQL Query tab:

where datefieldname = curdate()