Restricting groups from the sys_user_group_list when used as a reference variable

Helen Scheck1
Tera Contributor

Hello,

 

We have a couple of groups with access type of 'Security' that I would like to restrict from being displaying in the drop down on the catalog item.  I have previously tried using the sys_id of the groups in variable and using 'is not' function but they are still being displayed. I would either like to make them unavailable for all users or make only available to Admins.  
Suggestions are greatly appreciated.  I did try messing around w/BRs, UI Policies but outcome was not successful.

3 REPLIES 3

jcmings
Mega Sage

To confirm, the "Type" field on the sys_user_group table is = Security? Why can't you make that your filter?

 

jcmings_0-1751406050552.png

 

Another option (you really wouldn't need to do this when you can do the above) is to switch this to an Advanced reference qualifier and paste in the query there (to do this, I went to sys_user_group.list and built my filter, and copied it):

 

jcmings_1-1751406173661.png

 

Helen Scheck1
Tera Contributor

Mega,

Thanks for the reply!  The reason that I didn't use a filter of 'type' was because we have multiple security type groups but I just needed to filter out 3 because they have 'elevated' permissions.  I did try using the advanced filter with sys_id for those 3 but for some reason it isn't working.  I will continue to investigate.

 

You could also try filtering based on the name of the group or another characteristic. If you want to share your filter, I'm happy to help troubleshoot!