Database SQL Operation: DeterminationAnswer.searchByDeterminationQuestionnaireVersionKey
Description: | Returns determination answer identifier for the records for the given determination delivery ID and questionnaire version ID on Question entity. |
Sterotype: | nsmulti |
SELECT
DeterminationAnswer.determinationAnswerID
INTO
:determinationAnswerID
FROM
DeterminationAnswer,
QuestionnaireVersion
WHERE determinationDeliveryID = :determinationDeliveryID
AND questionID IN
(
SELECT
questionID
FROM
Question
WHERE questionnaireVersionID = :questionnaireVersionID
)
|