Filter records

acutri · Post by **acutri** » Sat Aug 24, 2013 11:17 pm

PHPMaker 10, Mysql

All the tables in my database have a field 'myfield'.
The user table (tbuser) contains, for each user, a value of the field 'myfield', eg.: 'Myvalue'.
I wish that after authentication tables are filtered with the value 'myvalue'

mobhar · Post by **mobhar** » Mon Aug 26, 2013 9:57 am

Similar to this post: http://www.hkvforums.com/viewtopic.php? ... 567#p92327

For example:
function Recordset_Selecting(&$filter) {
ew_AddFilter($filter, "myfield = 'Myvalue'"); // Add your own filter expression
}

acutri · Post by **acutri** » Mon Aug 26, 2013 9:30 pm

All db tables must have the filter 'myvalue'. The function Recordset_Selecting (& $ filter) is Table-specific
In addition, the value 'myvalue' must be read from the table tb_user at login

mobhar · Post by **mobhar** » Tue Aug 27, 2013 10:10 am

Then you should read "Tutorial - Advanced Security - User ID Security" in the help file.