project BLF > class BResource > business logic query ResourceByURIUsr
Parameters
| iiCompanyId | integer | Company id |
| icResourceURI | character | |
| iiUsrId | integer | |
| ilCompanyIsActive | logical | |
query condition
each Resources where
Resources.ResourceURI = icResourceURI
each RoleResource (inner-join) where
RoleResource.Resource_ID = Resources.Resource_ID AND
first Role (inner-join) where
Role.Role_ID = RoleResource.Role_ID AND
each UsrRoleCompany (inner-join) where
UsrRoleCompany.Company_Id = iiCompanyId AND
UsrRoleCompany.Role_ID = Role.Role_ID AND
UsrRoleCompany.Usr_ID = iiUsrId
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = UsrRoleCompany.Company_ID AND
Company.CompanyIsActive = ilCompanyIsActive
first Domains (inner-join) where
Domains.Domain_ID = UsrRoleCompany.Domain_ID AND
query resultset tqResourceByURIUsr
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | UsrRoleCompany.Company_ID | Entity |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tlCompanyIsActive | logical | Company.CompanyIsActive | Active |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tcResourceURI | character | Resources.ResourceURI | Universal Resource Identification |
| tiUsr_ID | integer | UsrRoleCompany.Usr_ID | User |
Internal usage
BLF
QadFinancials