project BLF > class BUser > business logic query UsrCompanyPrim

Description

Query used to convert the physical prim-key into the logical-prim-key and vice-versa


Parameters


iiCompanyIdintegerCompany id
iiUsrCompanyIDintegerUsrCompanyID
icUsrLogincharacter
icCompanyCodecharacterEntity Code


query condition


  each UsrCompany where
UsrCompany.Company_Id = iiCompanyId AND
UsrCompany.UsrCompany_ID = iiUsrCompanyID

      first Company (inner-join) where
Company.Company_Id = iiCompanyId AND
Company.Company_ID = UsrCompany.Company_ID AND
Company.CompanyCode = icCompanyCode

      first Usr (inner-join) where
Usr.Usr_ID = UsrCompany.Usr_ID AND
Usr.UsrLogin = icUsrLogin


query resultset tqUsrCompanyPrim


field namedata typedb fielddescription
tcUsrLogincharacterUsr.UsrLoginLogin
tiUsrCompany_IDintegerUsrCompany.UsrCompany_IDRecord ID
tcCompanyCodecharacterCompany.CompanyCodeEntity Code


Internal usage


BLF
method BUserRole.ApiSynchronise