Restrict access of tickets per group

[Pat Surtan]

Hello Everyone,

I have a custom table where 3 different teams can access. Team 1 can see all tickets. Team 2 can only see tickets assigned to their category and team 3  can only see tickets assigned to their category as well. How can I achieve this? Please provide detailed steps and thank you in advance.

[Naveen Vemula]

Hi,

You can handle the logic by making use of system properties.

1.create properties which stories different group name or sys_id of you choice

2. In the query BR making use of condition if you are  part of groups and not part of, before the get the logged in user sys_id using gs.getuserID  and check the membership by making glide record record to sys_user_grmember  table  and  kept user logics in current.addQuery i.e make use of user IN groups

//sample query

user.sys_id=^group.nameIN {invoke your system properties here} this will be less maintenance you just need to modify the system properties based on use case

3.And you can create a new SI(functions) to handle all the relevant logic membership 

[Pat Surtan]

Hello Naveen,

Unfortunately, my skill level is not up to par to create what you laid out. Are there any samples or scripts you can provide to assist? Can you walk me through your explanation?