project QadFinancials > class BUserRole > business logic query UserRoleDomainForMail
Parameters
| iiDomainId | integer | |
| iiRoleId | integer | |
query condition
each UsrRoleDomain where
UsrRoleDomain.Domain_ID = iiDomainId AND
UsrRoleDomain.Role_ID = iiRoleId
first Usr (inner-join) where
Usr.Usr_ID = UsrRoleDomain.Usr_ID AND
first Lng (inner-join) where
Lng.Lng_ID = Usr.DefaultLng_ID AND
query resultset tqUserRoleDomainForMail
| field name | data type | db field | description |
|---|
| tiDomain_ID | integer | UsrRoleDomain.Domain_ID | Domain |
| tiLng_ID | integer | Lng.Lng_ID | Record ID |
| tcLngCode | character | Lng.LngCode | Language Code |
| tiRole_ID | integer | UsrRoleDomain.Role_ID | Role |
| tiUsr_ID | integer | Usr.Usr_ID | Record ID |
| tcUsrMailAddress | character | Usr.UsrMailAddress | E-mail Address |
| tcUsrName | character | Usr.UsrName | User Name |
Internal usage
QadFinancials