AnsweredAssumed Answered

Enterprise Survey Reporting Using OpenDB

Question asked by ma36771 on Jul 31, 2017
Latest reply on Aug 3, 2017 by ma36771

We have been using Enterprise Surveys for end of course evaluations. The default reports are a huge hassle to collect/distribute and cannot show any trending, I'm trying to build a query using OpenDB so we can use custom Tableau reports but I'm not able to connect the survey results to a specific course or a faculty.. I've gotten as far as collecting the entire set of survey responses, see below, any help is extremely appreciated!;

 

Select SV.[ID]

      ,SV.[PK1]

      ,SV.[NAME]

,Q.[QTEXT_BODY]

,AC.[name] As AnswerChoice

,QR.[ANSWER_TEXT]

from [BlackBoard].[dbo].[CLP_SV_QUESTION_RESPONSE] QR

INNER JOIN [BlackBoard].[dbo].[CLP_SV_ANSWER_CHOICE] AC On QR.CLP_SV_ANSWER_CHOICE_PK1 = AC.PK1

Inner Join [BlackBoard].[dbo].[CLP_SV_SUBQUESTION] SQ On AC.CLP_SV_SUBQUESTION_PK1 = SQ.PK1

Inner Join [BlackBoard].[dbo].[CLP_SV_QUESTION] Q on SQ.CLP_SV_QUESTION_PK1 = Q.PK1

Inner Join [BlackBoard].[dbo].[CLP_SV_SURVEY_DEPLOYMENT] SD on SD.CLP_SV_SURVEY_PK1 = Q.CLP_SV_SURVEY_PK1

Inner Join [BlackBoard].[dbo].[CLP_SV_SURVEY] SV on SD.CLP_SV_SURVEY_PK1 = Sv.PK1

WHERE  SV.[NAME] like '%2017%Summer Term I%'

 

Thank you

Marwan

Outcomes