project BLF > class BResource > business logic query RolesForResource
Description
retrieve all roles to give access to a resource
Parameters
| iiResourceID | integer | |
| icResourceURI | character | |
| iiRoleID | integer | |
query condition
each Resources where
Resources.Resource_ID = iiResourceID AND
Resources.ResourceURI = icResourceURI
each RoleResource (inner-join) where
RoleResource.Resource_ID = Resources.Resource_ID AND
RoleResource.Role_ID = iiRoleID
first Role (inner-join) where
Role.Role_ID = RoleResource.Role_ID AND
query resultset tqRolesForResource
| field name | data type | db field | description |
|---|
| tiRole_ID | integer | Role.Role_ID | Record ID |
| tcRoleName | character | Role.RoleName | Role Name |
Internal usage
QadFinancials