I create first a grid that displays the list of user.
I create second grid thats displays the list of roles of the selected user.
Now, in other tab I displayed if the role is active for all the organizations or have access to specific organizations:
If the radioButton "Grant access to specific organizations individually" is selected , I want when I clicked on "next" I get the names of organizations where the selected role is active.
I added the OMUserRoleOrganization as dataSource , in the method executeQuery() I set this code:
public void executeQuery()
{
SysQuery::findOrCreateRange(this.query().dataSourceTable(tablenum(OMUserRoleOrganization)), fieldnum(OMUserRoleOrganization, User)).value(queryValue(UserInfo.id));
SysQuery::findOrCreateRange(this.query().dataSourceTable(tablenum(OMUserRoleOrganization)), fieldnum(OMUserRoleOrganization, SecurityRole)).value(queryValue(SecurityRole.RecId));
super();
}
Then I added OMInternalOrganization as datasource, in the method executeQuery() I set this code:
public void executeQuery()
{
SysQuery::findOrCreateRange(this.query().dataSourceTable(tablenum(OMInternalOrganization)), fieldnum(OMInternalOrganization, RecId)).value(queryValue(OMUserRoleOrganization.OMInternalOrganization));
super();
}
I called these methods in clicked Button, but I didn't get values.
I want to know how to link the userInfo, SecurityRole, OMUserRoleOrganization and OMInternalOrganization to get the names of organizations??
