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