project BLF > class BUser > business logic query UsrDomainByDomainLogin
Description
!DON't ADD CALCULATED FIELDS!
This is because this query needs to be able to run without an active session.
Parameters
| icUsrLogin | character | |
| icDomainCode | character | |
query condition
each Usr where
Usr.UsrLogin = icUsrLogin
each UsrDomain (inner-join) where
UsrDomain.Usr_ID = Usr.Usr_ID AND
first Domains (inner-join) where
Domains.Domain_ID = UsrDomain.Domain_ID AND
Domains.DomainCode = icDomainCode
query resultset tqUsrDomainByDomainLogin
| field name | data type | db field | description |
|---|
| tiDomain_ID | integer | Domains.Domain_ID | Record ID |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tcDomainDatabase | character | Domains.DomainDatabase | Database |
| tiPrimaryCompany_ID | integer | Domains.PrimaryCompany_ID | Primary Entity |
| tiUsr_ID | integer | Usr.Usr_ID | Record ID |
| tlUsrDomainIsDefault | logical | UsrDomain.UsrDomainIsDefault | indicates the default domain per user |
| tcUsrLogin | character | Usr.UsrLogin | Login |
Internal usage
BLF