Applying a filter on a lookup field WITH 'Inherit Access Permissions' enabled
Posted: 2017-01-25 17:40
Hi all,
I am somewhat stuck. I have a lookup pulldown list that needs to show a user all of his own records ONLY but that also have the status field set to 'Active'. So it needs to ignore all the ones with the status set to 'Inactive' but this has to apply on his own records ONLY and no one else's records.
When I go into Appgini and add 'WHERE `tablename`.`status` = 'Active' by clicking on the Advanced button and changing the sql, I have to turn off 'Inherit access permissions' or the Advanced button doesn't show. The problem is that I still need to inherit the permissions and run the where condition on those record that are inherited only. Does anyone know of a solution to this please?
Thank you
I am somewhat stuck. I have a lookup pulldown list that needs to show a user all of his own records ONLY but that also have the status field set to 'Active'. So it needs to ignore all the ones with the status set to 'Inactive' but this has to apply on his own records ONLY and no one else's records.
When I go into Appgini and add 'WHERE `tablename`.`status` = 'Active' by clicking on the Advanced button and changing the sql, I have to turn off 'Inherit access permissions' or the Advanced button doesn't show. The problem is that I still need to inherit the permissions and run the where condition on those record that are inherited only. Does anyone know of a solution to this please?
Thank you