project QadFinancials > class BDomain > business logic query DomainForSharedSet
Parameters
| iiDomainID | integer | Domain ID |
| icDomainCode | character | Domain Code |
query condition
each Domains where
Domains.Domain_ID = iiDomainID AND
Domains.DomainCode = icDomainCode
each DomainSharedSet (inner-join) where
DomainSharedSet.Domain_ID = Domains.Domain_ID AND
first SharedSet (inner-join) where
SharedSet.SharedSet_ID = DomainSharedSet.SharedSet_ID AND
query resultset tqDomainForSharedSet
| field name | data type | db field | description |
|---|
| tiDomain_ID | integer | Domains.Domain_ID | Record ID |
| tcDomainCode | character | Domains.DomainCode | Domain |
| tiDomainSharedSet_ID | integer | DomainSharedSet.DomainSharedSet_ID | Record ID |
| tiSharedSet_ID | integer | SharedSet.SharedSet_ID | Record ID |
| tcSharedSetCode | character | SharedSet.SharedSetCode | Shared Set Code |
| tcSharedSetDescription | character | SharedSet.SharedSetDescription | Shared Set Description |
| tlSharedSetIsActive | logical | SharedSet.SharedSetIsActive | Active |
| tcSharedSetTypeCode | character | SharedSet.SharedSetTypeCode | Shared Set Type |
Internal usage
QadFinancials