Database SQL Operation: Condition.searchConditionsForDC
Description: | |
Sterotype: | nsmulti |
SELECT
conditionDCLinkID,
Condition.name,
Condition.conditionID,
Condition.startDate,
Condition.endDate
INTO
:conditionDCLinkID,
:conditionName,
:conditionID,
:startDate,
:endDate
FROM
Condition,
ConditionDCLink,
DeterminationConfig
WHERE DeterminationConfig.determinationConfigID = :determinationConfigID
AND DeterminationConfig.determinationConfigID = ConditionDCLink.determinationConfigID
AND ConditionDCLink.conditionID = Condition.conditionID
ORDER BY Condition.name
|