2. PHPRunner General questions
  3. [SOLVED]  Displaying list page values based on table column value
This topic is locked
[SOLVED]

 Displaying list page values based on table column value

 		2/12/2014 9:07:50 AM
PHPRunner General questions
U
 U.M.Mbanaso author

Hi,

i have look through the forum but didn't find what i want, i want to display data of my database table in list page based on the status of a column in the table (that is the column value is either yes or no), i just want to know if it is to alter the sql generated on the sql page or not

thanks in advance
Sergey Kornilov admin 2/12/2014

While I'm not quite sure what exactly you trying to achieve but using 'View as' type Custom you can do that. You can access other field values there and can execute any PHP code as well:

http://xlinesoft.com/phprunner/docs/_view_as__settings_custom.htm
U
 		U.M.Mbanaso author 2/13/2014



While I'm not quite sure what exactly you trying to achieve but using 'View as' type Custom you can do that. You can access other field values there and can execute any PHP code as well:

http://xlinesoft.com/phprunner/docs/_view_as__settings_custom.htm



what i actually want to achieve is on the list page, i want only the records that the 'confirm' column is set to yes to be display not all the records in the table. how can i achieve that? thanks
Sergey Kornilov admin 2/13/2014

Modify SQL query on SQL query screen adding the following where clause:

where confirm='yes'
U
 		U.M.Mbanaso author 2/14/2014



Modify SQL query on SQL query screen adding the following where clause:

where confirm='yes'




thanks, it is done