...
Open your preferred text editor (i.e. Notepad).
Paste the following security file template into your text editor:
2Code Block <
securityDefinition
language 34567891011121314xml <securityDefinition xmlns="http://www.jaspersoft.com/2007/SL/XMLSchema"
version="1.0"
itemGroupDefaultAccess="granted">
<
resourceAccessGrants
>
<resourceAccessGrants> <!--Row level security -->
<
resourceAccessGrantList
<resourceAccessGrantList id="JoinTree_1_List"
label="ListLabel"
resourceId="JoinTree_1">
<
resourceAccessGrants
>
<resourceAccessGrants> <!--Row level for organisations -->
<
resourceAccessGrant
<resourceAccessGrant id="Jointree_1_row_access_grant_20">
<
principalExpression
>
<
><principalExpression><![CDATA[authentication.principal.attributes.any{it.attrName in ['userid'] }]]
</
principalExpression
>
<
filterExpression
>testProfileAttribute></principalExpression> <filterExpression>testProfileAttribute(mdl_pos_assignment.managerid,'userid')</
filterExpression
>
</
resourceAccessGrant
>
</
resourceAccessGrants
>
</
resourceAccessGrantList
>
</
resourceAccessGrants
>
</
securityDefinition
>
filterExpression> </resourceAccessGrant> </resourceAccessGrants> </resourceAccessGrantList> </resourceAccessGrants> </securityDefinition>
Save the security file XML on your computer with a unique name: "coursecompletion_manager_security.xml"
...