I have created a series of DR pages and would like to present the data in a summary page using several Dynamic view modules on the same page.
I noticed that I can retrieve data from a DF and the multiple questions are given unique column names so that each response can be inserted as a unique token on the page.
Is there a similar SQL query or procedure I can use or adapt to do the same thing for questions stored in DR? I can produce a list of DR questions from a SQL query but want to only use some of the question/response tokens and present them in a more suitlable way, similar to how DF and DV work together.
SELECT question, response ,DynamicRegistration_Question.sortorder from DynamicRegistration_Question JOIN DynamicRegistration_QuestionResponse ON DynamicRegistration_Question.DynamicQuestionID = DynamicRegistration_QuestionResponse.DynamicQuestionID where moduleid = 515 and userid = 5 and questionType <> 'HTML' order by DynamicRegistration_Question.sortorder