project QadFinancials > class BDomain > business logic query DomainsForName

Description

Query to retrieve Domain and DomainProperty Values


query condition


  each Domains where

      each DomainProperty (inner-join) where
DomainProperty.Domain_ID = Domains.Domain_ID AND


query sort order


Domains.DomainCode (ascending)


query resultset tqDomainsForName


field namedata typedb fielddescription
tlDomainPropertyIsSetupCompllogicalDomainProperty.DomainPropertyIsSetupComplSetup Complete
tiDomain_IDintegerDomains.Domain_IDRecord ID
tcDomainCodecharacterDomains.DomainCodeDomain
tcDomainTypecharacterDomains.DomainTypeType
tlDomainIsActivelogicalDomains.DomainIsActiveActive
tcDomainPropertyNamecharacterDomainProperty.DomainPropertyNameName
tcDomainPropertySearchNamecharacterDomainProperty.DomainPropertySearchNameSearch Name


Internal usage


QadFinancials
method BMfgCreditTerms.MaintainData
method BMfgCreditTermsDetail.MaintainData
method BUser.ApiGetUserDomainEntityAccess
method BUserRole.ApiGetUserMembership
method Session.GetDomainsAndCompaniesForUser