2. PHPRunner General questions
  3. Control List view to only show active records
This topic is locked

Control List view to only show active records

 		5/13/2012 3:02:59 PM
PHPRunner General questions
milsimcorps author

I would like to hide records that are no longer active in the LIST VIEW. Is it possible to create a script that would hide inactive records in the LIST VIEW. I have tons of records but some are no longer active. I don't want to delete these inactive records but I also don't want them to show in my list view. I have created a field in the table called "Status" with the options to choose between "Active" and "Inactive".
Thank you in advance for your assistance and quick response.
C
 		cgphp 5/13/2012

In the "List page: Before SQL query", enter this code:

$strWhereClause = "Status = 'Active'";