project BLF > class BUser > business logic query UserCompanies
Description
User has access to these companies
!DON't ADD CALCULATED FIELDS!
This is because this query needs to be able to run without an active session.
Parameters
icUserLogin | character | User Login |
iiCyId | integer | company_id |
iiDomainId | integer | |
query condition
each Usr where
Usr.UsrLogin = icUserLogin
first Lng (outer-join) where
Lng.Lng_ID = Usr.DefaultLng_ID AND
each UsrCompany (inner-join) where
UsrCompany.Usr_ID = Usr.Usr_ID AND
UsrCompany.Company_ID = iiCyId
first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = UsrCompany.Company_ID AND
Company.Domain_ID = iiDomainId
query resultset tqUserCompanies
field name | data type | db field | description |
tcCompanyDescription | character | Company.CompanyDescription | Entity Description |
tiDomain_ID | integer | Company.Domain_ID | Domain |
tcLngCode | character | Lng.LngCode | Language Code |
tiCompany_ID | integer | Company.Company_ID | Record ID |
tcCompanyCode | character | Company.CompanyCode | Entity Code |
Internal usage
BLF
QadFinancials