Operation Details |
Description: | Lists all outcomes that are not associated with the goal specified, having a specific record status. |
Sterotype: | nsmulti |
SQL |
SELECT outcomeID, name, dateCreated INTO :outcomeID, :name, :dateCreated FROM Outcome WHERE recordStatus = :outcomeRecordStatus AND outcomeID NOT IN ( SELECT outcomeID FROM GoalOutcomeLink WHERE goalID = :goalID ) |