project QadFinancials > class BSafConcept > business logic query GetActiveSafStrctrBySafConcept
Parameters
query condition
each SafConcept where
SafConcept.SafConcept_ID = iiSafConceptID
each SafStructureLine (inner-join) where
SafStructureLine.SafConcept_ID = SafConcept.SafConcept_ID AND
first SafStructure (inner-join) where
SafStructure.SafStructure_ID = SafStructureLine.SafStructure_ID AND
SafStructure.SafStructureIsActive = true
query resultset tqGetActiveSafStrctrBySafConcept
| field name | data type | db field | description |
|---|
| tiSafConcept_ID | integer | SafConcept.SafConcept_ID | Record ID |
| tlSafStructureIsActive | logical | SafStructure.SafStructureIsActive | Active |
| ti_sequence | integer | calculated | primary index |
| tc_rowid | character | calculated | = rowid(SafConcept),rowid(SafStructureLine),rowid(SafStructure) |
Internal usage
QadFinancials