Check out the LimeSurvey source code on GitHub!
Welcome, Guest
Username: Password:

TOPIC: SQL Statement for External Reporting

SQL Statement for External Reporting 4 years 2 weeks ago #88795

  • helper
  • helper's Avatar
  • Offline
  • Expert Lime
  • Posts: 126
  • Thank you received: 18
  • Karma: 0
Has anybody put together a SQL statement that puts the survey results together with the question (AND sub-question where appropriate) to the answer (not the code, but the actual answer)?
The administrator has disabled public write access.

SQL Statement for External Reporting 4 years 1 week ago #89095

  • helper
  • helper's Avatar
  • Offline
  • Expert Lime
  • Posts: 126
  • Thank you received: 18
  • Karma: 0
okay... how about a database schema diagram?
The administrator has disabled public write access.

SQL Statement for External Reporting 4 years 1 week ago #89118

  • DenisChenu
  • DenisChenu's Avatar
  • Online
  • Moderator Lime
  • Posts: 9580
  • Thank you received: 1374
  • Karma: 390
It's in export_helper.php i think Menno work a lot in export_helper.php.

You want a "one line SQL" ? Think it's OK for question, maybe more work for sub question.

Denis
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (use private message).
The administrator has disabled public write access.
Time to create page: 0.319 seconds
Imprint                   Privacy policy         General Terms & Conditions         Revocation information and revocation form