Issue with my security file

[srahmani]

Hello I am trying to implement a new security file on my jaspersoft instance and am getting the following errors when trying to save my domain. I do not think this is an XML error but possibly something more specific to jaspersoft server when trying to load the file. otherwise i am not sure why this isn't working. Any help on this would be greatly appreciated!

There is a problem with the security file
The following field(s) can not be found:

The filter condition 'testProfileAttribute(dw_analytics_dim_faculty.faculty_username, 'username')' references one or more fields that cannot be found: ID [dw_analytics_dim_faculty.faculty_username].
The filter condition 'testProfileAttribute(dw_analytics_dim_graders_rls.grader_username, 'username')' references one or more fields that cannot be found: ID [dw_analytics_dim_graders_rls.grader_username].
The filter condition 'testProfileAttribute(dw_analytics_dim_coach.coach_username, 'username')' references one or more fields that cannot be found: ID [dw_analytics_dim_coach.coach_username].
The filter condition 'testProfileAttribute(dw_analytics_users_workspaces_rls.username, 'username')' references one or more fields that cannot be found: ID [dw_analytics_users_workspaces_rls.username].

here is my formatted XML:

<?xml version="1.0" encoding="UTF-8"?>
<securityDefinition xmlns="http://www.jaspersoft.com/2007/SL/XMLSchema" version="1.0" itemGroupDefaultAccess="granted">
<resourceAccessGrants>
<resourceAccessGrantList id="JoinTree_1_resource_access_grant" label="aLabel" resourceId="JoinTree_1">
<resourceAccessGrants>
<resourceAccessGrant id="Jointree_1_row_access_grant_faculty">
<principalExpression><![CDATA[authentication.getPrincipal().getRoles().any{it.getRoleName() in ['ROLE_FACULTY']}]]></principalExpression>
<filterExpression>testProfileAttribute(dw_analytics_dim_faculty.faculty_username,'username')</filterExpression>
</resourceAccessGrant>
<resourceAccessGrant id="Jointree_1_row_access_grant_grader">
<principalExpression><![CDATA[authentication.getPrincipal().getRoles().any{it.getRoleName() in ['ROLE_GRADER']}]]></principalExpression>
<filterExpression>testProfileAttribute(dw_analytics_dim_graders_rls.grader_username,'username')</filterExpression>
</resourceAccessGrant>
<resourceAccessGrant id="Jointree_1_row_access_grant_coach">
<principalExpression><![CDATA[authentication.getPrincipal().getRoles().any{it.getRoleName() in ['ROLE_COACH']} && !(attributesService.getAttribute('tenant','USER')?.getAttrValue().contains('brandman'))]]></principalExpression>
<filterExpression>testProfileAttribute(dw_analytics_dim_coach.coach_username,'username')</filterExpression>
</resourceAccessGrant>
<resourceAccessGrant id="Jointree_1_row_access_grant_workspaces">
<principalExpression><![CDATA[authentication.getPrincipal().getRoles().any{it.getRoleName() in ['ROLE_ADMIN','ROLE_COACH','ROLE_FACULTY','ROLE_GRADER']}]]></principalExpression>
<filterExpression>testProfileAttribute(dw_analytics_users_workspaces_rls.username,'username')</filterExpression>
</resourceAccessGrant>
</resourceAccessGrants>
</resourceAccessGrantList>
</resourceAccessGrants>
</securityDefinition>

[srahmani]

answer to this is below

[srahmani]

so I figured this out, the filter expression reads directly off of your joins from the tables so in some domains in our system the alias of the table read with "dw_analytics..." and in my case it was just the name of the view or table without that. Once I made that change in the xml it was accepted.