Read Access to specific users to HR Cases - Total Rewards

[_Samay]

Hello Friends,

Good Day!

We have one requirement where we needed some help.

We have created a record producer on Total Rewards table and also mapped with a HR Service, once users will submitted HR cases for total rewards we are also setting assignment group and short description for those cases so we can segregate.

But, our client wants that HR cases that are getting created should be visible to only users having a specific location and job code on user table.

We have written On Before Query business where we are checking if logged in user having this location or job then return encoded query where HR service = xyz. But, it’s not working as expected.

We have also tried to written Read ACL on HR core table and Total Rewards But we are not getting expected results.

Can anyone please help me on this like how we can achieve this.

[SumanthDosapati]

@_Samay Please share screenshot of what you have tried in ACL/BR

[abirakundu23]

Hi @_Samay 

Please share your screenshots that you have built.

[_Samay]

Hi @abirakundu23 @SumanthDosapati  Thanks for your message. Pls check ?

[_Samay]

ACL Script, and We have write this on Total Rewards table and also we tried to HR Case Table. Where we have put condition for HR Services

On Before Query Business Rules 

Team, Please let me know if this is okay. ?