project BLF > class BUserRole > business logic query UserRoleByUserRole
Parameters
| iiUsrID | integer | |
| iiRoleID | integer | |
| ilUsrRoleIsDefaultRole | logical | |
| icRoleName | character | |
| icUsrLogin | character | |
| icUsrName | character | |
query condition
each UsrRole where
UsrRole.Usr_ID = iiUsrID AND
UsrRole.Role_ID = iiRoleID AND
UsrRole.UsrRoleIsDefaultRole = ilUsrRoleIsDefaultRole
first Role (inner-join) where
Role.Role_ID = UsrRole.Role_ID AND
Role.RoleName = icRoleName
first Usr (inner-join) where
Usr.Usr_ID = UsrRole.Usr_ID AND
Usr.UsrLogin = icUsrLogin AND
Usr.UsrName = icUsrName
query resultset tqUserRoleByUserRole
| field name | data type | db field | description |
|---|
| tiRole_ID | integer | UsrRole.Role_ID | Role |
| tlRoleIsActive | logical | Role.RoleIsActive | Act |
| tcRoleName | character | Role.RoleName | Role Name |
| tiUsr_ID | integer | UsrRole.Usr_ID | User |
| tcUsrLogin | character | Usr.UsrLogin | Login |
| tcUsrName | character | Usr.UsrName | User Name |
| tiUsrRole_ID | integer | UsrRole.UsrRole_ID | Record ID |
| tlUsrRoleIsDefaultRole | logical | UsrRole.UsrRoleIsDefaultRole | Indicates the default role per user. |
Internal usage
BLF