Trying to write a reference qualifier for the approver field on a change request form.

[wendellkubik]

 I need to pull from a Change_Approver group that contains all managers, and a Change_Approver_Delegates group that I must limit to the delegated approvers for the same department as the assigned_to in the current change request.

I'm using a script include to pull the members of the Change Approver group put I need to pull from two assignment groups and put the additional restriction of the same department on the delegates group.

Here is a sample of what i have but I am having trouble getting the script include to pule from two groups

javascript: new ACMEUserGroupUtils().getGroupMembers(gs.getProperty('change.approval.groups'), current.assigned_to) + "^department=" +current.assigned_to.department

script include below

var ACMEUserGroupUtils = Class.create();

ACMEUserGroupUtils.prototype = {

                initialize: function() {

                },

                /*

                                getGroupMembers() function returns the list of the group members of the

                                groupName passed as a parameter.

                */

                getGroupMembers: function(groupName, excludeUsers) {

                                var answer = [];

                                var grMember = new GlideRecord('sys_user_grmember');

                                grMember.addQuery('group.name', groupName);

                                grMember.query();

                                if (excludeUsers != '') {

                                                while (grMember.next()) {

                                                                if (excludeUsers.indexOf(grMember.user.toString()) == -1) {

                                                                                answer.push(grMember.user.toString());

                                                                }

                                                }

                                }

                                return 'sys_idIN' + answer.toString();

                },

                /*

                                isUserInGroup(): returns the user only if the user is a member of the group, empty otherwise.

                                Note: does not return boolean as function name would suggest.

                */

                isUserInGroup: function(user, group) {

                                //returns user if they are a mmember of the group.

                                var answer = '';

                                if (gs.getUser().getUserByID(user).isMemberOf(group)) {

                                                answer = user;

                                }

                                return answer;

                },            

                type: 'ACMEUserGroupUtils'

};

[wendellkubik]

I wrote the following script include

var ACMECTaskTestUtil = Class.create();

ACMECTaskTestUtil.prototype = {

    initialize: function() {

    },

                excludeFunction:function(){

if(current.u_change_task_type=='Test'){

return "sys_id!=" + current.change_request.u_approver + "^sys_id!=" + current.change_request.requested_by + "^sys_id!=" +current.change_request.assigned_to;}

                },

    type: 'ACMECTaskTestUtil'

};

and then I put the following in the reference qualifier to call the script include

javascript: new ACMECTaskTestUtil().excludeFunction()

..and it's not working  😞   Please help

[Abhinay Erra]

what is the field type u_change_task-type? If it is a choice type, you will have to put in the choice value not the label

[wendellkubik]

The field type for u_change_task_type is string .  But is a choice called Test in the related Links.   See attached image

Not sure if this is treated like a choice.

[Abhinay Erra]

so your script include should look like this

var ACMECTaskTestUtil = Class.create();

ACMECTaskTestUtil.prototype = {

    initialize: function() {

    },

                excludeFunction:function(){

if(current.u_change_task_type=='test'){

return "sys_id!=" + current.change_request.u_approver + "^sys_id!=" + current.change_request.requested_by + "^sys_id!=" +current.change_request.assigned_to;}

                },

    type: 'ACMECTaskTestUtil'

};

[wendellkubik]

I see it now the value is "test" but the Label is "Test"

Thanks...Ill give it a try