How to export the essay question type in the question bank

Stephen Ladek

• January 12, 2023 22:07

May I ask how to export the essay question type in the question bank?

Because I want to export and choose a specific essay question type but I cannot find an option to do it.

Thanks in advance.

0

• 

  Jason Rodgers

  • February 08, 2023 17:13

  Does this possibly get you what you need?

  SELECT q.questiontext, q.name AS questionname, q.qtype as questiontype, mdl_quiz.name as QuizName, mdl_course.fullname as CourseName 
  FROM mdl_quiz_slots slot 
  INNER JOIN mdl_question_references qr ON qr.component = 'mod_quiz' AND qr.questionarea = 'slot' AND qr.itemid = slot.id 
  INNER JOIN mdl_question_bank_entries qbe ON qbe.id = qr.questionbankentryid 
  INNER JOIN mdl_question_versions qv ON qv.questionbankentryid = qbe.id 
  INNER JOIN mdl_question q ON q.id = qv.questionid 
  INNER JOIN mdl_quiz ON mdl_quiz.id = slot.quizid 
  INNER JOIN mdl_course ON mdl_course.id = mdl_quiz.course
  WHERE q.qtype='essay'

  0

Please sign in to leave a comment.