Reference qualifiers not working as expected

[Kamatham Suman1]

Hlo folks,
When I click on 'assigned to' field in Incident. It should accept only users who are part of 'assignement group' selected. But when i click on 'assigned to' field it is showing the recent selections, when i click them it should show it as invalid if selectd user is not part of assignment group selected but it is not happening it is accepting.
Can anyone help on this.
Thanks in advance!

[Dr Atul G- LNG]

Hi @Kamatham Suman1 

Assigned to is depend on Assignment group and due to this issue is there

[Kamatham Suman1]

Hi @Dr Atul G- LNG,
my issue is it is accepting the users are not part of the assignment group also.
Thankyou for response!

[Dr Atul G- LNG]

Agree , this is what the OOTB system provides. I just tested and it is working. In this case you need to make Assignment group mandatory. OOTB it is not mandatory so it is moving forward.

[Satishkumar B]

Hi @Kamatham Suman1 

for your scenario you may need to use script include to get the group and call in your client script:

Create a Script Include

Name: ValidateUserInGroup
Client Callable: True

var ValidateUserInGroup = Class.create();

ValidateUserInGroup.prototype = Object.extendsObject(AbstractAjaxProcessor, {

    validateUserInGroup: function() {

        var userId = this.getParameter('sys_id');

        var groupId = this.getParameter('group_id');

        var userGroupGR = new GlideRecord('sys_user_grmember');

        userGroupGR.addQuery('user', userId);

        userGroupGR.addQuery('group', groupId);

        userGroupGR.query();

        return userGroupGR.hasNext();

    }

});

Client Script for Assignment Group Field

Type: OnChange
Table: Incident
Field: Assignment Group

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

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

        return;

    }

    // Store the new assignment group value

    g_form.setValue('assignment_group', newValue);

    // Validate if the current 'Assigned to' user is valid

    validateAssignedTo();

}

function validateAssignedTo() {

    var assignedTo = g_form.getValue('assigned_to');

    var assignmentGroup = g_form.getValue('assignment_group');

    if (assignedTo && assignmentGroup) {

        var ga = new GlideAjax('ValidateUserInGroup');

        ga.addParam('sys_id', assignedTo);

        ga.addParam('group_id', assignmentGroup);

        ga.getXMLAnswer(function(response) {

            if (response === 'false') {

                g_form.showFieldMsg('assigned_to', 'The selected user is not part of the selected assignment group.', 'error');

                g_form.setValue('assigned_to', '');

            }

        });

    }

}

Client Script for Assigned to Field

Type: OnChange
Table: Incident
Field: Assigned To

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

    if (isLoading) {

        return;

    }

    validateAssignedTo();

}

function validateAssignedTo() {

    var assignedTo = g_form.getValue('assigned_to');

    var assignmentGroup = g_form.getValue('assignment_group');

    if (assignedTo && assignmentGroup) {

        var ga = new GlideAjax('ValidateUserInGroup');

        ga.addParam('sys_id', assignedTo);

        ga.addParam('group_id', assignmentGroup);

        ga.getXMLAnswer(function(response) {

            if (response === 'false') {

                g_form.showFieldMsg('assigned_to', 'The selected user is not part of the selected assignment group.', 'error');

                g_form.setValue('assigned_to', '');

            }

        });

    }

}

…………………………………………..
Mark it helpful 👍and Accept Solution ✅!! If this helps you to understand.