project QadFinancials > class BRole > business logic query UsrRoleByRole
Description
User information by role
Parameters
| iiRoleID | integer | RoleId |
| icRoleName | character | RoleName |
query condition
each Role where
Role.Role_ID = iiRoleID AND
Role.RoleName = icRoleName
each UsrRole (inner-join) where
UsrRole.Role_ID = Role.Role_ID AND
first Usr (inner-join) where
Usr.Usr_ID = UsrRole.Usr_ID AND
query resultset tqUsrRoleByRole
| field name | data type | db field | description |
|---|
| tiRole_ID | integer | Role.Role_ID | Record ID |
| tcRoleName | character | Role.RoleName | Role Name |
| tiUsr_ID | integer | Usr.Usr_ID | Record ID |
| tcUsrInitials | character | Usr.UsrInitials | UsrInitials |
| tlUsrIsActive | logical | Usr.UsrIsActive | Active |
| tcUsrLogin | character | Usr.UsrLogin | Login |
| tcUsrMailAddress | character | Usr.UsrMailAddress | E-mail Address |
| tcUsrName | character | Usr.UsrName | User Name |
| tiUsrRole_ID | integer | UsrRole.UsrRole_ID | Record ID |
Internal usage
QadFinancials