project QadFinancials > class BRole > business logic query UsrRoleByBusActivity
Description
Return all users that can use a certain activity.
Parameters
| ilRoleIsActive | logical | RoleIsActive |
| ilUsrIsActive | logical | UsrIsActive |
| iiBusActivityId | integer | |
query condition
each RoleResource where
first Resources (inner-join) where
Resources.Resource_ID = RoleResource.Resource_ID AND
Resources.BusActivity_ID = iiBusActivityId
first Role (inner-join) where
Role.Role_ID = RoleResource.Role_ID AND
Role.RoleIsActive = ilRoleIsActive
each UsrRole (inner-join) where
UsrRole.Role_ID = Role.Role_ID AND
first Usr (inner-join) where
Usr.Usr_ID = UsrRole.Usr_ID AND
Usr.UsrIsActive = ilUsrIsActive
query resultset tqUsrRoleByBusActivity
| field name | data type | db field | description |
|---|
| tiBusActivity_ID | integer | Resources.BusActivity_ID | Business Activity |
| tiResource_ID | integer | RoleResource.Resource_ID | Resource |
| tiRole_ID | integer | RoleResource.Role_ID | Role |
| tlRoleIsActive | logical | Role.RoleIsActive | Act |
| tcRoleName | character | Role.RoleName | Role Name |
| tiUsr_ID | integer | UsrRole.Usr_ID | User |
| tlUsrIsActive | logical | Usr.UsrIsActive | Active |
| tcUsrLogin | character | Usr.UsrLogin | Login |
| tcUsrName | character | Usr.UsrName | User Name |
Internal usage
QadFinancials