Hi,
I have form that contains 4 datasources like this:
1.UserInfo.
2.SecurityUserRole that has relation with UserInfo:linkType=delayed.
3.SecurityRole that has relation with securityUserRole : LinkType=InnerJoin.
4.EukMatrixRole that has relation with securityRole:linkType=Delayed.
I add executeQuery in SecurityUserRole :
public void executeQuery()
{
this.query().dataSourceTable(tableNum(SecurityUserRole)).addRange(fieldNum(SecurityUserRole, AssignmentStatus)).value(queryValue(RoleAssignmentStatus::Enabled));
this.query().dataSourceTable(tableNum(SecurityRole)).addRange(fieldNum(SecurityRole,Name)).value('!Utilisateur système');//to display roles except UserSystem
super();
}
I add executeQuery in eukMatrixRole :
public void executeQuery()
{
this.query().dataSourceTable(tableNum(EUKMatrixRole)).addRange(fieldNum(EUKMatrixRole,MatrixName)).value(queryValue(SecurityRole.Name));//
super();
}
but when I run the form I don't get the exact values from eukmatrixRole according to the securityRole Name:
