How can a person with a specific role access the View? (View Rule not working)

[tk37]

I would like to allow a person holding a specific role to access the following View.

(I want to allow role holders to access other people's ess views.)
・Table : sys_user
・View : ess
・Role : u_itsm_counter

I created the following View Rule Script, but it did not work.
I would appreciate anyone's help.

・Script

(function overrideView(view, is_list) {
answer = view;
if (gs.hasRole('u_itsm_counter')) {
answer = "ess";
}
})(view, is_list);

[newhand]

@tk37 

I think i found the reason!

If the user is a  admin ,  hasrole() function will always retun true(even not existed role name )!

use the below function to check if the user has a specific  role .

(I have not debuged this script , so if it goes wrong , debug and modify it please.)

function checkrole(role,user_id){   
            var rol = new GlideRecord('sys_user_role');
               rol.addQuery('name', role);
               rol.query();
               if (rol.next()) {
                       var hasRole = new GlideRecord('sys_user_has_role');
                       hasRole.addQuery('user', user_id);
                       hasRole.addQuery('role', rol.sys_id);
                       hasRole.query();
                       if (hasRole.next()) {
                               return true;
                       } else {
                               return false;
                       }
               }
               return false;
}

[tk37]

Thank you for your response.
I will try it.

[tk37]

I tried the Script you gave me.
It worked with the Background Script, but not with the View Rule.
There may be a cause other than the Script.

[newhand]

@tk37 

View Rule runs on the server side，so i think the script can work well。

Can post your  whole script ？

[tk37]

@newhand 

Thank you for your response.

The scripts that were implemented are as follows.

(function overrideView(view, is_list) {
    var currentUser = gs.getUserID();
	if(!checkrole('u_itsm_counter',currentUser))
	{return;}
	answer = "ess";
	
	function checkrole(role,user_id){   
            var rol = new GlideRecord('sys_user_role');
               rol.addQuery('name', role);
               rol.query();
               if (rol.next()) {
                       var hasRole = new GlideRecord('sys_user_has_role');
                       hasRole.addQuery('user', user_id);
                       hasRole.addQuery('role', rol.sys_id);
                       hasRole.query();
                       if (hasRole.next()) {
                               return true;
                       } else {
                               return false;
                       }
               }
               return false;
	}
})(view, is_list);

View Rule

Result

View cannot be selected.