project BLF > class BUser > business logic query UsrDefaultDomainCompany
Parameters
| iiUsrID | integer | |
| icUsrLogin | character | |
query condition
each Usr where
Usr.Usr_ID = iiUsrID AND
Usr.UsrLogin = icUsrLogin
each UsrDomain (inner-join) where
UsrDomain.Usr_ID = Usr.Usr_ID AND
UsrDomain.UsrDomainIsDefault = TRUE
first Domains (inner-join) where
Domains.Domain_ID = UsrDomain.Domain_ID AND
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = Domains.PrimaryCompany_ID AND
each UsrCompany (inner-join) where
UsrCompany.Company_Id = iiCompanyId AND
UsrCompany.Company_ID = Company.Company_ID AND
UsrCompany.Usr_ID = UsrDomain1.Usr_ID
query resultset tqUsrDefaultDomainCompany
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tlCompanyIsActive | logical | Company.CompanyIsActive | Active |
| tiDomain_ID | integer | Domains.Domain_ID | Record ID |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tlDomainIsActive | logical | Domains.DomainIsActive | Active |
| tiUsr_ID | integer | Usr.Usr_ID | Record ID |
| tlUsrIsActive | logical | Usr.UsrIsActive | Active |
| tcUsrLogin | character | Usr.UsrLogin | Login |
Internal usage
BLF