project QadFinancials > class BDomain > business logic query DomainsByCodeActiveSetup
Parameters
| icDomainCode | character | Domain Code |
| ilActive | logical | Active |
| ilSetupComplete | logical | Domain is flagged for Setup Complete |
query condition
each Domains where
Domains.DomainCode = icDomainCode AND
Domains.DomainIsActive = ilActive
each DomainProperty (inner-join) where
DomainProperty.Domain_ID = Domains.Domain_ID AND
DomainProperty.DomainPropertyIsSetupCompl = ilSetupComplete
query resultset tqDomainsByCodeActiveSetup
| field name | data type | db field | description |
|---|
| tcDomainCode | character | Domains.DomainCode | Domain |
| tlDomainIsActive | logical | Domains.DomainIsActive | Active |
| tlDomainPropertyIsSetupCompl | logical | DomainProperty.DomainPropertyIsSetupCompl | Setup Complete |
Internal usage
QadFinancials