Please help us help you and fill where relevant: Your LimeSurvey version: 3.28.32+221011 Own server or LimeSurvey hosting: Own Survey theme/template: Vanilla
==================
I'm looking for a method to export a list of all the questions in a survey, grouped by question group, and including question code. Need this as a helpful reference for reviewing CSV exported responses.
Basically, looking for a report like:
Group 1 title
[Q1} text of the question
[Q2] text of this question
[Q3] text of question 3
Group 2 title
[Q4} text of the question
[Q5] text of this question
etc...
Where the question code is rendered between the square brackets.
For anyone who has access to mySQL, here's a query that will return group name, question code, and question text:
Code:
SELECT hq.type, hg.group_name, hq.title, hq.question
FROM `lime_questions` hq
INNER JOIN `lime_groups` hg ON hq.gid = hg.gid
WHERE hq.sid =999999 and hq.type NOT IN ('T')
ORDER BY hg.group_name
