project BLF > class BUserRole > business logic query UsrRoleByUsrId


Parameters


iiUsrIdinteger
iiCompanyIdintegerCompany id


query condition


  each UsrRole where
UsrRole.Usr_ID = iiUsrId

      first Role (inner-join) where
Role.Role_ID = UsrRole.Role_ID AND

      each UsrRoleCompany (outer-join) where
UsrRoleCompany.Company_Id = iiCompanyId AND
UsrRoleCompany.UsrRole_ID = UsrRole.UsrRole_ID AND

          first Company (outer-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = UsrRoleCompany.Company_ID AND


query resultset tqUsrRoleByUsrId


field namedata typedb fielddescription
tiCompany_IDintegerUsrRoleCompany.Company_IDEntity
tcCompanyCodecharacterCompany.CompanyCodeEntity Code
tiDomain_IDintegerCompany.Domain_IDDomain
tiRole_IDintegerRole.Role_IDRecord ID
tcRoleDescriptioncharacterRole.RoleDescriptionRoleDescription
tlRoleIsActivelogicalRole.RoleIsActiveAct
tcRoleNamecharacterRole.RoleNameRole Name
tiUsr_IDintegerUsrRole.Usr_IDUser
tiUsrRole_IDintegerUsrRole.UsrRole_IDRecord ID
tiUsrRoleCompany_IDintegerUsrRoleCompany.UsrRoleCompany_IDRecord ID
tlUsrRoleIsDefaultRolelogicalUsrRole.UsrRoleIsDefaultRoleIndicates the default role per user.


Internal usage


BLF
method BUserRole.ApiGetUserRoles

QadFinancials
method BJournal.ApiLoadJournal
method TJournalRole.CheckJournalRole