Get User groups list from Requested For

[Ram050670]

Hi All,

i would like to get List of groups (type = request) of user from requested for to a reference type field.

can someone help me with Script include and advanced reference qualifier.

Thanks in advance!

[Harsh_Deep]

Hello @Ram050670 

Please delete your all the codes and do this code, Please match every line and word.

getUserRequestGroups: function(userId) {

        var groups = [];

        var gr = new GlideRecord('sys_user_grmember');

        gr.addEncodedQuery('user='+userId+'^group.typeLIKE'+'1cb8ab9bff500200158bffffffffff62');

        gr.query();

        while (gr.next()) {

            groups.push(gr.sys_id.toString());

        }

        return 'sys_idIN'+groups;

    },

And use this in Variable

Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Harsh

[Ram050670]

Ok so look like we are close, i know that user has 2 groups with type request but its not showing the group name

[Ram050670]

i was able to see the groups using variable attribute but when selected created is shown

[Harsh_Deep]

Hello @Ram050670 

Open "sys_db_object.LIST" then serach for "sys_user_grmember" table then open it.

Then scroll down and you will get Columns name.

Click on the gear icon and take display field on the list view and make it true for group column and save it.

Please mark this comment as Correct Answer/Helpful if it helped you.
Regards,
Harsh

[Ram050670 · Accepted solution]

I would say this is the right way to do it on this request!!

--------------Script Include------------------------

getUserRequestGroups: function(userId) {

        var Gtype = gs.getProperty("Assignment_Group_Type");

        var gFilter = gs.getProperty("Assignment_Group_Dynamic_user");

        var groups = [];

        var gr = new GlideRecord('sys_user_grmember');

        gr.addEncodedQuery('group.typeLIKE' + Gtype + '^userDYNAMIC' + gFilter);

        gr.query();

        while (gr.next()) {

            groups.push(gr.group.sys_id.toString());

        }

        return 'sys_idIN' + groups;

    },

-----------------------Reference Qualifier-------------------------

javascript: new catalogClientUtil().getUserRequestGroups();