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