Catalog Client Script with Script Include to populate a Group select box from a User selection

[Jason Thornton]

Hello community! First time crying for help!

I am working on a service catalog item.

I am trying to use a script include and catalog client script (posted below, adapted from one I found here) and it's not working.

My use case is, the end user selects a user from a reference select box, that pre-populates the owner_asg select box only with groups that user is a member of.

The end user can change the user and the owner_asg box should change available groups to the new users groups.

I'm open to other solutions but thought the script include was the way to go. Any help is appreciated.

Script include:

var GroupsMembership = Class.create();

GroupsMembership.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getGroups: function() {

        var groups = [];

        var user = this.getParameter('sysparm_userID');

        var gr = new GlideRecord('sys_user_grmember');

        gr.addQuery('user', user);

        gr.query();

        while (gr.next()) {

            groups.push(gr.groups.getDisplayValue());

        }

        return groups.toString();

    },

    type: 'GroupsMembership'

});

Catalog Client Script:

function onChange(control, oldValue, newValue, isLoading, isTemplate) {

    if (isLoading || newValue === '') {

        return;

    }

    var gajax = new GlideAjax('GroupsMembership');

    gajax.addParam('sysparm_name','getGroups');

    gajax.addParam('sysparm_userID', newValue);

    gajax.getXML(getResults);

}

function getResults(response){

    var answer = response.responseXML.documentElement.getAttribute("answer");

    g_form.setValue('owner_asg', answer);

}

[Sandeep Rajput]

@Jason Thornton Could you please update the getResults as follows.

function getResults(response){
    var answer = response.responseXML.documentElement.getAttribute("answer");
    var answerArray = answer.split(',');
    for(var i=0; i<answerArray.length;i++){
       g_form.addOption('owner_asg',answerArray[i],answerArray[i]); // Assuming owner_asg is a select box which shows group names.
    }    
}

Hope this helps.

[Jason Thornton]

That still brings back ALL groups. I'm not sure what I'm missing.

[Jason Thornton]

My user variable name is 'crep_owner' in the catalog item. Does that make a difference in my script include?

[Sandeep Rajput]

@Jason Thornton Found a typo at line   groups.push(gr.groups.getDisplayValue()); in script include.

Please update your script include script as follows.

var GroupsMembership = Class.create();
GroupsMembership.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getGroups: function() {
        var groups = [];
        var user = this.getParameter('sysparm_userID');
        var gr = new GlideRecord('sys_user_grmember');
        gr.addQuery('user', user);
        gr.query();
        while (gr.next()) {
            groups.push(gr.group.getDisplayValue());
        }
        return groups.toString();
    },

    type: 'GroupsMembership'
});

Hope this helps.