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