As
It is important to note that HRSD ships with several query business rules already named "restrict query". These are there to restrict access to cases for general employees and NOT HR agents. You can create a new one and I would recommend following the similar name as I called it Restrict query Agents:
Then on the advanced tab set the condition to:
gs.isInteractive() && new hr_Utils().checkUserHasRole("sn_hr_core.basic") && !new hr_Utils().checkUserHasRole("sn_hr_core.admin")
This query will only fire with an "interactive" session meaning using the UI versus an interface- this is important for integrations and other background processes querying for cases. Then it checks to see if the user HAS the sn_hr_core.basic user and does NOT have the sn_hr_core.admin role. This way admin's can still query for all cases.
Then set the script to the following:
(function executeRule(current, previous /*null when async*/) {
current.addQuery("assignment_group", "javascript:getMyGroups()");
})(current, previous);
This will insert a behind the scenes query of assignment group matching any group that the logged in user is a member of.
Remember that this query can and will fire for every single query to the HR Case table. So regression testing is super important!
Please mark this post as helpful or the correct answer if applicable so others viewing may benefit.
