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.