Database SQL Operation: DeterminationAnswer.searchConsolidatedQuestionsByDD
Description: | This method retrieves Consolidated/UnConsolidated question answer details for the given determination delivery ID |
Sterotype: | nsmulti |
SELECT
DISTINCT Question.questionID,
aliasText,
name
INTO
:questionID,
:questionText,
:questionnaireName
FROM
QuestionnaireVersion,
Question,
QuestionAlias,
DeterminationAnswer
WHERE DeterminationAnswer.determinationDeliveryID = :determinationDeliveryID
AND DeterminationAnswer.consolidationInd = :consolidationInd
AND DeterminationAnswer.questionID = Question.questionID
AND Question.questionnaireVersionID = QuestionnaireVersion.questionnaireVersionID
AND QuestionAlias.questionID = Question.questionID
AND QuestionAlias.type = :aliasType
|