How to restrict access via Before Query Business Rule?

[SNOW Developer6]

Hi,

I am working on Before Query Business Rule.

I want to show the requested_for records to  requested_for user who is logged in.

I have written the following code but its not working.I am only getting blank page.

Can u please look at it ?

(function ExecuteRule(current,previous)
{   
         if(gs.hasRole('myrole') && gs.getSession().isInteractive())
{
           current.addQuery('requested_for','==',gs.getUserID());
}

})(current,previous);

I dont know why its not working.

[Cris P · Accepted solution]

Hello, please try as below (remove the '==')

(function ExecuteRule(current,previous){   
         if(gs.hasRole('myrole') && gs.getSession().isInteractive()){
           current.addQuery('requested_for', gs.getUserID());
}
})(current,previous);

[Musab Rasheed]

Hello,

It should be single '=' not '=='

This worked for me

current.addQuery('requested_for','=',gs.getUserID());

Regards

[Muhammad Khan]

Hi,

It would be better if you utilize the condition field of Business Rule, so that it will only be executed when condition is met. See the below image for reference.

[SNOW Developer6]

Thank you so much for your answer.

Its working now.

I want the admin to view all the records.

I tried this but I am getting blank page for the admin role.What should I do for the admin.

(function ExecuteRule(current,previous){   
         if(gs.hasRole('admin') && gs.getSession().isInteractive()){
         current.query();
}
})(current,previous);