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

TOPIC: SQL Statement for External Reporting

SQL Statement for External Reporting 3 years 9 months 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 3 years 8 months 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 3 years 8 months ago #89118

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • Moderator Lime
  • Posts: 9298
  • Thank you received: 1330
  • Karma: 386
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 developpement are on my free time (Say thanks ?).
A bug not reported is a bug not corrected. | Please, read the documentation | La doc en français à besoin de vous
The administrator has disabled public write access.
Moderators: ITEd
Time to create page: 0.298 seconds
Imprint                   Data Protection Statement                  Revocation information and revocation form