Filter Users by Department and Role using Reference Qualifier with Script Include in ServiceNow

[muneermajeed]

I used a Script Include + Reference Qualifier approach:

• Used GlideRecord on has role table to find all users with ITIL role.

• Retrieved current user’s department.

• Returned a custom query using  sysIDs IN and department in the Script Include.

var refrence_qulifier_dep_and_role_task_02 = Class.create();
refrence_qulifier_dep_and_role_task_02.prototype = Object.extendsObject(AbstractAjaxProcessor, {

   check_dep_role: function() {

        var gr = new GlideRecord('sys_user_has_role');
        gr.addEncodedQuery('role.name=itil');
        gr.query();

        var hasitilrole = [];
        while (gr.next()) {
            hasitilrole.push(gr.user.sys_id.toString());
           

        }

        var dep;
        var gr2 = new GlideRecord('sys_user');
        if (gr2.get(gs.getUserID())) {
            dep = gr2.department.sys_id.toString();
        }
        return 'sys_idIN' + hasitilrole+'^department='+dep ;

    },


    type: 'refrence_qulifier_dep_and_role_task_02'
});