project BLF > class BUser > business logic query UserByRoleId


Parameters


iiRoleIdinteger
ilUsrIsActivelogical
iiCompanyIdintegerCompany id


query condition


  each Usr where
Usr.UsrIsActive = ilUsrIsActive

      each UsrRole (inner-join) where
UsrRole.Usr_ID = Usr.Usr_ID AND
UsrRole.Role_ID = iiRoleId

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


query resultset tqUserByRoleId


field namedata typedb fielddescription
tiRole_IDintegerUsrRole.Role_IDRole
tiUsr_IDintegerUsrRole.Usr_IDUser
tcUsrMailAddresscharacterUsr.UsrMailAddressE-mail Address
tcUsrNamecharacterUsr.UsrNameUser Name


Internal usage


BLF
method BReportDaemonProcessor.PerformWorkItem
method BReportRequestBase.ValidateComponent
method BWorkObject.PostSave