show all the groups that user is member of

[dev_K]

Hello,

I have a catalog item with a field where user can select a group he belongs to.

In the ESC it shows me the 'created' value but I would prefer the name.

How this can be fixed?

[Rajesh Chopade1]

hi @dev_K 

Ensure that the reference field in your catalog item is using the correct display field from the sys_user_group table.

Look for the dictionary entry for the field that you are interested in. If you don't see it immediately, you can search using the Name field (like "name").

Ensure that the Display checkbox is checked for the name field. This means it will be used as the display value for the reference field.

If you have custom fields that you want to use as display values, you can also ensure that their Display checkbox is checked.

i hope my answer helps you to resolve your issue, if yes please mark my answer helpful and correct.

thank you

rajesh

[Sai25]

Hi,

Reference should be group table.

javascript:getGroups(current.variables.your_field_name);//Reference Qualifier
create a script include and call in the reference qualifier.

function getGroups(grp_id) {

        var answer = [];

        var mem = new GlideRecord('sys_user_grmember');

        mem.addQuery('user', grp_id);

        mem.query();

        while (mem.next()) {

                 answer.push(mem.getValue("group"));

        }

    return "sys_idIN" + answer.join();

[Sandeep Rajput]

@dev_K Please use the following steps to fix this issue.

Configure the Group Member table as follows.

2. Set the Display field to true for Group field.

Refresh the page and you should be able to see the group name in the group field.

Hope this helps.