Advanced reference qualifier to hide a value of a reference variable based on user's department

[xhensilahad]

Hi everyone,

I have a requirement to hide a value of a reference field, if the users department starts with BT.

I have written the Script Include below:

Script Include:

var getUserDetails = Class.create();

getUserDetails.prototype = {

    initialize: function() {},

    // Method to get department filter based on user ID

    getFilter: function(userID) {

        var userGR = new GlideRecord('sys_user');

        if (userGR.get(userID)) {

            var department = userGR.department.name; 

            if (department && department.substring(0, 2) !== 'BT') {

                return 'active=true^name!=IT Infrastuktur';

            }

        }

    }

};

How do i call this Script include in my Advanced Reference qualifier script? Thank you

[Simon Christens · Accepted solution]

try:

javascript: new getUserDetails().getFilter(gs.getUserID())

[Siddhesh2 · Accepted solution]

Hello @xhensilahad ,

You should uncheck the client callable option and use below code to call script include.

[xhensilahad]

I have updated the *Script Include*

[Simon Christens]

You can add gs.addInfoMessage() in your script include so that you can see that it gets called.

Then you can make some messages in your script to see where it goes wrong.

When you then click on the search icon on the field then you should see those messages

[Brad Bowman]

Your Reference qualifier should look like this:

[xhensilahad]

Hi Brad, thank you for your response. 

Can you please review my Script Include as I can still see the variable in the Portal:

Script Include: (Client callable has been checked)

var getUserDetails = Class.create();

getUserDetails.prototype = {

    initialize: function() {},

    getFilter: function(userID) {

        var userGR = new GlideRecord('sys_user');

        gs.info(userGR);

        if (userGR.get(userID)) {

            var department = userGR.department.name;

            if (department && department.substring(0, 2) === 'BT') {

                return 'active=true';

            } else {

                return 'active=true^name!=IT Infrastuktur';

            }

        }

    }

};

Thank you

[Brad Bowman]

In this case Client callable is not required, but it doesn't hurt anything to have it checked.  Checking this box after a script exists does not add the extended object to the script, but even if it did it would still work with a qualifier.  You can temporarily add some lines like this to confirm the script is running, the value passed in from the qualifier, and the substring, then you should see where it is going wrong:

var getUserDetails = Class.create();
getUserDetails.prototype = {
    initialize: function() {},
    getFilter: function(userID) {
		gs.addInfoMessage('SI running ' + userID);
        var userGR = new GlideRecord('sys_user');
        if (userGR.get(userID)) {
            var department = userGR.department.name.toString();
			gs.addInfoMessage('SI dept ' + department);
			gs.addInfoMessage('si dept substring ' + department.substring(0, 2));
            if (department && department.substring(0, 2) === 'BT') {
                return 'active=true';
            } else {
                return 'active=true^name!=IT Infrastuktur';
            }
        }

    }
};