project QadFinancials > class BResource > business logic query ResourceByUsrDomainUri
Description
Query returns all roles for which a user can access a given mfgpro function within a given domain.
Can only be used for mfgpro functions, not for white activities.
Parameters
| iiUsrID | integer | |
| iiDomainID | integer | |
| icResourceURI | character | |
query condition
each Resources where
Resources.ResourceType = 'M' and
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 UsrRoleDomain (inner-join) where
UsrRoleDomain.Role_ID = Role.Role_ID AND
UsrRoleDomain.Domain_ID = iiDomainID and
UsrRoleDomain.Usr_ID = iiUsrID
query resultset tqResourceByUsrDomainUri
| field name | data type | db field | description |
|---|
| tiDomain_ID | integer | UsrRoleDomain.Domain_ID | Domain |
| tcResourceURI | character | Resources.ResourceURI | Universal Resource Identification |
| tiUsr_ID | integer | UsrRoleDomain.Usr_ID | User |
Internal usage
QadFinancials