project BLF > class BUser > business logic query UserByRoleId
Parameters
iiRoleId | integer | |
ilUsrIsActive | logical | |
iiCompanyId | integer | Company 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 name | data type | db field | description |
tiRole_ID | integer | UsrRole.Role_ID | Role |
tiUsr_ID | integer | UsrRole.Usr_ID | User |
tcUsrMailAddress | character | Usr.UsrMailAddress | E-mail Address |
tcUsrName | character | Usr.UsrName | User Name |
Internal usage
BLF