The crux of the issue is (while testing in a non-prod instance):
- Added a reference varable to the sys_user table called 'Default Group' (u_default_group), which refers back to the Group Member list (sys_user_grmember).
- In the User form, when I click the magnifying glass, the popup list that opens up only shows sys_id
Things I've done in trying to make the popup list show actual group names:
- In Dictionary Entries > Table = sys_user_grmember, found 'Group' and set 'Display' to true
- In Dictionary Entries > Table = sys_user_group, found 'Name' and set 'Display' true
Those changes did have one effect: When I start typing a value into the 'Default Group' variable box now, the auto-complete/suggested, human-legible group names actually do show up (see below 1), but it's still showing only the sys_id if I click the magnifying glass icon (see below 2).
"below 1"
"below 2"
Additionally, when the auto-complete options show up (as I start typing a value), they show multiple values for each group (Note: I understand *why* multiple values are showing up--because the table referenced holds many-to-one (group-to-user) values. I just need it to only show unique group names if possible.
And some background on why I'm doing this (in case someone can think of a better way): The end goal here is to be able to employ a script that sets the 'Assigned to' on an Incident to the current user if its state is changed to Active and that field is empty.
- Presently this script does not (cannot) work because
- If 'Assigned to' is not empty, then 'Assignment group' must not be empty (I don't want to change this), and
- The 'Assigned to' field is dependent on the 'Assignment group' field (i.e., the individual must be a member of the group selected).
So I did some research and found someone recommendations to create a 'Default Group' variable in the sys_user table, which I was working on testing, in order to be able to set up some additional script logic that will change/set the 'Assignment group' to the current user's default group where applicable (if current user is not a member of the current assignment group or if the assignment group is empty).
PS - This is my first post in the community. I've only been administering SN for my company since Sept. last year. Thank you all in advance for your help here.
