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


icUserLogincharacterUser Login
iiCyIdintegercompany_id
iiDomainIdinteger


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 namedata typedb fielddescription
tcCompanyDescriptioncharacterCompany.CompanyDescriptionEntity Description
tiDomain_IDintegerCompany.Domain_IDDomain
tcLngCodecharacterLng.LngCodeLanguage Code
tiCompany_IDintegerCompany.Company_IDRecord ID
tcCompanyCodecharacterCompany.CompanyCodeEntity Code


Internal usage


BLF
method BBaseDaemon.ValidateComponent
method BUser.ApiEntitySecurityCheck
method Session.ApplicationLogin
method Session.CheckLogin
method Session.GetCompanyListForUserAndDomain
method Session.GetDomainsAndCompaniesForUser
method Session.Login
method Session.SwitchCompany
method TDaemon.DaemonLogin

QadFinancials
method BCompany.ValidateComponentCheckSecurity