Need to populate groupmembers based on group

Vinay49
Tera Expert

Hello,

We have 2 reference fields on form. 1 is referring to group table & other is group member table.

My requirement here is to Populate group members in 2nd reference field based on the group that we have selected in 1st reference field.

Can anyone help with this code to get users of selected groups & populate on 2nd refernce field.

Client script:

function onChange(control, oldValue, newValue, isLoading) {
    if (isLoading || newValue == '') {
        return;
    }
    var answer;
    var ga = new GlideAjax('c_populateGroupUsers');
    ga.addParam('sysparm_name', 'getUsers');
    ga.addParam('sysparm_user', newValue);
    ga.getXML(getGroupUsers);
    function getGroupUsers(response) {
        answer = response.responseXML.documentElement.getAttribute("answer");
        var res = answer;
            alert(res);       
    }
    g_form.setValue('select_users', answer);
}

Script Include:
var c_populateGroupUsers= Class.create();
c_populateGroupUsers.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    getUsers: function() {
        var arr = [];
        var group= this.getParameter('sysparm_user');
        var gr = new GlideRecord('sys_user_grmember');
        gr.addQuery('group', group);
        gr.query();
        while (gr.next()) {
            arr.push(gr.user);
           
        }
        return JSON.encode(arr);
    },
    type: 'c_populateGroupUsers'
});
6 REPLIES 6

Thank you so much sir for helping

Resolved my issue, Thanks!