Issue while Using profile attributes in security file for a domain

[goyalrich]

Hello,

 

I have created a domain with security , I want to apply row level security to get the restricted data.

All users have PROJECT_ID set as profile attribute, I want the user should get the records of their project only.

<principalExpression><![CDATA[authentication.getPrincipal().getAttributes().any{

it.getAttrName() in ['PROJECT'] }]]></principalExpression>           

            <filterExpression>testProfileAttribute(PROJECT_ID, 'PROJECT_ID')</filterExpression>

        </resourceAccessGrant>

 

When I am creating a adhoc view out of this domain, I get the data of that project only, but cannot apply addition filters on other fields through adhoc view.

What is the soultion for this?

 

[elizam]

I can create filters with profile attributes set up.  I use testProfileAttribute, as described in the Ultimate Guide.One thing to look out for is that if the fields are restricted for certain users because of the profile attributes, that will not always work well. When you create reports formj tthe Ad HOc view, they also don't always restrict properly.

[goyalrich]

I got it working. Mistakenly I was not using the fully qualified column name.