I would like to create my own generic inquiry that links the RelationGroup table to the Users table - I’m guessing that there is an intermediate table that I haven’t found yet. The goal is to have a generic inquiry that gives me all the restriction groups that the users belong to. If you have managed to do this, I would be grateful if you could share some insights!
Question
How to create a generic inquiry that links RelationGroup to Users?
+16Hi
I created a Generic inquiry long ago for one of my requirements.
Could you please check if this helps
Hi
Thank you so much, I did see your post, and I did test this generic inquiry, thank you for sharing it. Unfortunately this isn’t working correctly, it is showing every user as having access to every RelationGroup. It is because of the way it is linked, there is no PKID for users in the RelationGroup:
The block in red needs to show a field from the RelationGroup table, and there doesn’t seem to be anything there that is shared with the Users Table. If I find a solution, I will let you know!
+11What determines the membership to a specific group is the “GroupMask” field that to the best of my knowledge only with code you can decipher it. Code is not complicated but then you will need a screen for it to display the result as you can not use GI. the code that identifies the relation is something like “PX.SM.UserAccess.IsIncluded(Base.Users.Current.GroupMask, RelationGroup)”
Hi
Login to the community
No account yet? Create an account
Social Login
Login with your Acumatica accountEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.