project QadFinancials > class BSaf > business logic query SafBySSOthers
Description
SafBySSOthers; query on main-table with from/to filter-values on Code , matching filter-value on Code, Equal filter-value on code, filter-value for BudgetGroupID and a filter-value for the SaherdSet.
Parameters
icFromSafCode | character | FromSafCode |
icToSafCode | character | ToSafCode |
icSafConceptCode | character | SAF Concept Code |
iiSafConceptID | integer | SafConceptId |
icMatchingSafCode | character | MatchingSafCode |
icSafCode | character | SAF Code |
iiBudgetGroupID | integer | BudgetGroupID |
query condition
each Saf where
Saf.SafCode >= icFromSafCode AND
Saf.SafCode <= icToSafCode AND
Saf.SafConcept_ID = iiSafConceptID AND
Saf.SafCode = icSafCode AND
Saf.SafCode matches icMatchingSafCode AND
Saf.BudgetGroup_ID = iiBudgetGroupID
first SafConcept (inner-join) where
SafConcept.SafConcept_ID = Saf.SafConcept_ID AND
SafConcept.SafConceptCode = icSafConceptCode
query resultset tqSafBySSOthers
field name | data type | db field | description |
tiSaf_ID | integer | Saf.Saf_ID | Record ID |
tcSafCode | character | Saf.SafCode | SAF Code |
tiBudgetGroup_ID | integer | Saf.BudgetGroup_ID | Budget Group |
tiSafConcept_ID | integer | Saf.SafConcept_ID | SAF Concept Code |
tcSafConceptCode | character | SafConcept.SafConceptCode | SAF Concept Code |
Internal usage
QadFinancials