project BLF > class BUser > business logic query UsrCompanyByLoginCompDomain
Parameters
| iiCompanyId | integer | Company id |
| icUserLogin | character | |
| icCompanyCode | character | |
| icDomainCode | character | |
| iiDomainId | integer | |
| iiUserId | integer | |
query condition
each UsrCompany where
UsrCompany.Company_Id = iiCompanyId AND
UsrCompany.Domain_ID = iiDomainId AND
UsrCompany.Usr_ID = iiUserId
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = UsrCompany.Company_ID AND
Company.CompanyCode = icCompanyCode
first Domains (inner-join) where
Domains.Domain_ID = UsrCompany.Domain_ID AND
Domains.DomainCode = icDomainCode
first Usr (inner-join) where
Usr.Usr_ID = UsrCompany.Usr_ID AND
Usr.UsrLogin = icUserLogin
query resultset tqUsrCompanyByLoginCompDomain
| field name | data type | db field | description |
|---|
| tiCompany_ID | integer | Company.Company_ID | Record ID |
| tcCompanyCode | character | Company.CompanyCode | Entity Code |
| tcCompanyDescription | character | Company.CompanyDescription | Entity Description |
| tiDomain_ID | integer | UsrCompany.Domain_ID | Domain |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tiUsr_ID | integer | UsrCompany.Usr_ID | User |
| tcUsrLogin | character | Usr.UsrLogin | Login |
| tcUsrName | character | Usr.UsrName | User Name |
Internal usage
BLF