Database SQL Operation: DeterminationAnswer.searchDAIDsByDDIDAndQVID
Description: | Gets all the answer IDs for the given determination delivery and the questionnaire version.
|
Sterotype: | nsmulti |
SELECT
determinationAnswerID INTO :determinationAnswerID
FROM
DeterminationAnswer DA1,
Question Q1
WHERE DA1.determinationDeliveryID = :determinationDeliveryID
AND Q1.questionnaireVersionID = :questionnaireVersionID
AND DA1.questionID = Q1.questionID
AND DA1.lastUpdatedDateTime IN
(
SELECT
MAX(lastUpdatedDateTime)
FROM
DeterminationAnswer DA2,
Question Q2
WHERE DA2.determinationDeliveryID = :determinationDeliveryID
AND Q2.questionnaireVersionID = :questionnaireVersionID
AND DA2.questionID = Q2.questionID
GROUP
BY Q2.questionID
)
|