project BLF > class BUserRole > business logic query ResourceMatrixByUser
Description
Make a list of all resources accessible by a specific user, excluding resources that cannot be used SOD.
Parameters
| iiCompanyId | integer | Company id |
| iiUsrID | integer | |
| iiDomainID | integer | |
| iiSODCategoryID | integer | |
query condition
each UsrRoleCompany where
UsrRoleCompany.Company_Id = iiCompanyId AND
UsrRoleCompany.Usr_ID = iiUsrID AND
UsrRoleCompany.Domain_ID = iiDomainID
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = UsrRoleCompany.Company_ID AND
first Domains (inner-join) where
Domains.Domain_ID = UsrRoleCompany.Domain_ID AND
first Role (inner-join) where
Role.Role_ID = UsrRoleCompany.Role_ID AND
Role.RoleSODException = false
each RoleResource (inner-join) where
RoleResource.Role_ID = Role.Role_ID AND
first Resources (inner-join) where
Resources.Resource_ID = RoleResource.Resource_ID AND
Resources.SODcategory_ID = iiSODCategoryID AND
Resources.SODcategory_ID <> 0
query resultset tqResourceMatrixByUser
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tiDomain_ID | integer | Domains.Domain_ID | Record ID |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tiResource_ID | integer | Resources.Resource_ID | Record ID |
| tcResourceURI | character | Resources.ResourceURI | Universal Resource Identification |
| tiRole_ID | integer | Role.Role_ID | Record ID |
| tcRoleName | character | Role.RoleName | Role Name |
| tiSODcategory_ID | integer | Resources.SODcategory_ID | Segregation of Duties Category reference |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(UsrRoleCompany),rowid(Company),rowid(Domains),rowid(Role),rowid(RoleResource),rowid(Resources) |
Internal usage
BLF