RLS

[karthik77700]

I have an requirement in RLS where i should create role and  they should see this below  data.

First it should check for Canada user  .And then it should have matching id and not NA.

And then my result should have  resulting Canada  match id with assciated client id.

Identity Matchid	Source Clientid	Policy Issue  Country
2023-12-12  CL 123	CN1234	Canada
2023-12-12  CL 123	HK456	Hong Kong
2023-12-12  CL 123	ID789	Indonesia
2023-12-12  CL 456	CN564	Canada

And when viewing by role then the assoicate id should be masked 

Identity Matchid	Source Clientid	Policy Issue  Country
2023-12-12  CL 123	CN1234	Canada
2023-12-12  CL 123	***56	Hong Kong
2023-12-12  CL 123	***89	Indonesia
2023-12-12  CL 456	CN564	Canada

Please help me on this request