project BLF > class BUser > business logic query UsrDomainByUserDomain
Parameters
| iiUserId | integer | |
| iiDomainId | integer | |
| icUserLogin | character | |
| icDomainCode | character | |
query condition
each UsrDomain where
UsrDomain.Domain_ID = iiDomainId AND
UsrDomain.Usr_ID = iiUserId
first Domains (inner-join) where
Domains.Domain_ID = UsrDomain.Domain_ID AND
Domains.DomainCode = icDomainCode
first Usr (inner-join) where
Usr.Usr_ID = UsrDomain.Usr_ID AND
Usr.UsrLogin = icUserLogin
query resultset tqUsrDomainByUserDomain
| field name | data type | db field | description |
|---|
| tiDomain_ID | integer | UsrDomain.Domain_ID | Domain |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tiUsr_ID | integer | UsrDomain.Usr_ID | User |
| tlUsrDomainIsDefault | logical | UsrDomain.UsrDomainIsDefault | indicates the default domain per user |
| tcUsrLogin | character | Usr.UsrLogin | Login |
Internal usage
BLF