Developer Forum

Jyothi76
Tera Contributor

‎08-05-2024 03:47 AM

Hi Team,

I have one requirement: Populate assigned to field based on assignment group in the catalog item and When we are not select any assignment group, in the assigned to field I need to show all users. Could you please help me on this I need to complete it by today.

The below code I have written:

var ReferenceQualifierUtility = Class.create();
ReferenceQualifierUtility.prototype = {
    initialize: function() {
    },

assignedDependency:function(group){
//gs.log('To check script');
gs.info('group is' + group);
//var group = current.variables.assignment_group;
var user_array = [];
if(group!==''){
var getMembers = new GlideRecord('sys_user_grmember');
getMembers.addQuery('group',group.toString());
getMembers.query();
while(getMembers.next()){
    //gs.log('To check loop')
    user_array.push(getMembers.getValue('user'));
}  
gs.info('user array is'+ user_array);
return 'sys_idIN' + user_array.toString();
}
else{
return 'active = true';
}

  },

    type: 'ReferenceQualifierUtility'
};

Advanced qualifier in the assigned to field:
javascript:new ReferenceQualifierUtility().assignedDependency(current.variables.assignment_group)



Thanks,
Jyothi
0 Helpfuls
  • 530 Views
2 REPLIES 2

Neeraj31
Mega Sage

‎08-07-2024 08:09 AM

Hello,

 

You have used "!==" instead of "!=" in your code if(group!==''){

 

Please consider marking my reply as Helpful and/or Accept Solution, if applicable. Thanks!

 

 

0 Helpfuls

Sid_Takali
Kilo Patron

‎08-07-2024 10:58 AM

Hi @Jyothi76 Try this 

var ReferenceQualifierUtility = Class.create();
ReferenceQualifierUtility.prototype = {
    initialize: function() {},

    assignedDependency: function(group) {
        var userArray = [];
        if (group) {
            // Query users in the given group
            var getMembers = new GlideRecord('sys_user_grmember');
            getMembers.addQuery('group', group);
            getMembers.query();
            while (getMembers.next()) {
                userArray.push(getMembers.getValue('user'));
            }
            return 'sys_idIN' + userArray.join(',');
        } else {
            return 'active=true';
        }
    },
    type: 'ReferenceQualifierUtility'
};

Reference Qualifier

javascript:new ReferenceQualifierUtility().assignedDependency(current.variables.assignment_group)
0 Helpfuls