⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Hide records depending on inserted value



Paolo

Paolo
  • profile picture
  • Member

Posted 27 September 2015 - 21:26 PM

Hi everybody,

 

thanks for the great job you are doing with GroceryCrud, which I just installed.

Maybe you have a solution to my problem (I searched the forum, but could find no help).

 

I would like to hide some records in a view (or simply NOT extract them) depending on the value registered in one column.

Example: in a table with 'Name', 'Surname', 'Active' fields, is it possible to show only the records where 'Active' field is set to 'Yes' and hide (or not extract) the records with 'Active'= 'No'?

I tried with the 'Where' clause, but it doesn't work: records with 'Active'='NO' can be viewed just using the filters, while they should not be seen by end user.

 

Thanks for your help.

Paolo