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