project BLF > class BUser > business logic query UsrDomainPrim


Parameters


icUsrLogincharacter
icDomainCodecharacter
iiUsrDomainIdinteger


query condition


  each UsrDomain where
UsrDomain.UsrDomain_ID = iiUsrDomainId

      first Domains (inner-join) where
Domains.Domain_ID = UsrDomain.Domain_ID AND
Domains.DomainCode = icDomainCode

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


query resultset tqUsrDomainPrim


field namedata typedb fielddescription
tcDomainCodecharacterDomains.DomainCodeDomain
tiUsrDomain_IDintegerUsrDomain.UsrDomain_IDRecord ID
tcUsrLogincharacterUsr.UsrLoginLogin


Internal usage


BLF
method BUserRole.ApiSynchronise