Operation Details |
Description: | Lists baseline name and ID details by caseID, excluding baseline defined by the key value of baseline ID. |
Sterotype: | nsmulti |
SQL |
SELECT Baseline.baseLineID, Baseline.name INTO :baseLineID, :name FROM Baseline, PlannedGoal WHERE PlannedGoal.caseID = :caseID AND Baseline.plannedGoalID = PlannedGoal.plannedGoalID AND Baseline.baseLineID <> :baseLineID |