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


iiUsrIDinteger
iiDomainIDinteger
icResourceURIcharacter


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 namedata typedb fielddescription
tiDomain_IDintegerUsrRoleDomain.Domain_IDDomain
tcResourceURIcharacterResources.ResourceURIUniversal Resource Identification
tiUsr_IDintegerUsrRoleDomain.Usr_IDUser


Internal usage


QadFinancials
method BResource.ApiMfgproFunctionIsAllowed