Applying a filter on a lookup field WITH 'Inherit Access Permissions' enabled

If you're a new user of AppGini, feel free to ask general usage questions, or look for answers here.
Post Reply
thecomputerchap
Veteran Member
Posts: 47
Joined: 2016-08-28 10:37

Applying a filter on a lookup field WITH 'Inherit Access Permissions' enabled

Post by thecomputerchap » 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 :)


User avatar
dilitimor
Veteran Member
Posts: 36
Joined: 2013-01-10 02:45
Location: Jakarta, Indonesia
Contact:

Re: Applying a filter on a lookup field WITH 'Inherit Access Permissions' enabled

Post by dilitimor » 2017-03-17 16:23

I need this feature too
I have an idea to add one field, where this field value is username (you can assign username from automatic value in AG
but I do not know how to call username in query

Post Reply