Populate the logged in user's group

[Samiksha2]

Hi All,

I have created a Reference field in the Requested Item.(Requester Group- Reference to sys_group table). 

The requirement is to show the logged in user's group in that field without adding any reference qualifier in the dictionary because this field is been used in other scripts.

Please help in this. 

Thanks,

Samiksha

[AnveshKumar M]

Hi @Samiksha2 

What if the user is member of multiple groups?

[Samiksha2]

Hi @AnveshKumar M ,

Thanks for your reply. 

It should populate the 1st group.

Thanks,

Samiksha

[AnveshKumar M · Accepted solution]

@Samiksha2 

Please use the following BR with the script to populate the first group upon RITM creation.

(function executeRule(current, previous /*null when async*/ ) {
    var gr = new GlideRecord("sys_user_grmember");
    gr.addQuery("user", current.requested_for);
    gr.query();
    if (gr.next()) {
        current.u_requester_group = gr.getValue('group'); //Change field name as per your configuration
    }
})(current, previous);

[AnveshKumar M]

To populate Logged in user (requester) group, instead of requested for use the following script.

(function executeRule(current, previous /*null when async*/ ) {
    var gr = new GlideRecord("sys_user_grmember");
    gr.addQuery("user", gs.getUserID());
    gr.query();
    if (gr.next()) {
        current.u_requester_group = gr.getValue('group'); //Change field name as per your configuration
    }
})(current, previous);