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


icFromSafCodecharacterFromSafCode
icToSafCodecharacterToSafCode
icSafConceptCodecharacterSAF Concept Code
iiSafConceptIDintegerSafConceptId
icMatchingSafCodecharacterMatchingSafCode
icSafCodecharacterSAF Code
iiBudgetGroupIDintegerBudgetGroupID


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 namedata typedb fielddescription
tiSaf_IDintegerSaf.Saf_IDRecord ID
tcSafCodecharacterSaf.SafCodeSAF Code
tiBudgetGroup_IDintegerSaf.BudgetGroup_IDBudget Group
tiSafConcept_IDintegerSaf.SafConcept_IDSAF Concept Code
tcSafConceptCodecharacterSafConcept.SafConceptCodeSAF Concept Code


Internal usage


QadFinancials
method BBudget.BudgetCheckFDSOverlapSub1
method BBudget.BudgetCheckInfoResolveQueryStop
method BBudget.BudgetCheckInfoResolveReadWBSSub
method BBudget.BudgetWBSCreateMultiple
method BBudget.CheckBudgetFDSwithWBSID