2. PHPRunner General questions
  3. [SOLVED]  Only Show Certain Records in List Page
This topic is locked
[SOLVED]

 Only Show Certain Records in List Page

 		5/12/2011 16:10:20
PHPRunner General questions
M
 mrphp author

Hello,
I want to create a custom view that only lists records which have an entry in a particular field. For example, if a record has a field for entering the MAC address of a computer, the record would not appear in the list if no MAC address were entered.
Thanks for any help.
Sergey Kornilov admin 5/12/2011

You can modify SQL Query adding the following WHERE clause:

WHERE MAC<>''
M
 		mrphp author 5/13/2011



You can modify SQL Query adding the following WHERE clause:

WHERE MAC<>''



Thank you.