Welcome, Guest
Username: Password: Remember me
  • Page:
  • 1
  • 2

TOPIC: SQL query for report builder

SQL query for report builder 4 years 8 months ago #36527

  • snowball
  • snowball's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
What is the SQL query that is needed to extract individual reports from the database when using a third party software for report building?
I have looked at the printanswers.php file, but I get stuck when trying to "translate" it to a SQL query.
No problem to donate if I could get the answer.
The administrator has disabled public write access.

Re:SQL query for report builder 4 years 8 months ago #36529

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5325
  • Thank you received: 296
  • Karma: 249
Here is the link to the database layout from the docs: docs.limesurvey.org/tiki-index.php?page=...meSurvey+Development

Also check manual -> SGQA identifier. Each answer has such an identifier which is used as column name within the "lime_survey_12345" table which holds all answer data for a certain survey.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re:SQL query for report builder 4 years 7 months ago #37051

  • snowball
  • snowball's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 2
  • Karma: 0
Thanks for the reply. I had a look at it but I did not find what I have been looking for. I cannot imagine that there are no other users who need more professional reporting than what is offered by limesurvey. As long as limesurvey offers only limited reporting it would be helpful to support users at least with providing the sql query so they can use other software for reporting. The exporting formats are not a solution as it offers little flexibility and need too much handwork.
The administrator has disabled public write access.

Re:SQL query for report builder 4 years 7 months ago #37059

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5325
  • Thank you received: 296
  • Karma: 249
Hi, I answered to your email directly.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re:SQL query for report builder 4 years 3 months ago #43868

  • gigipaul
  • gigipaul's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 1
  • Karma: 0
Hello,
I am also interested in getting the results out of the lime surveys with assessment values, so we can generate reports out of it. Please let me know
Thanks
Gigi
The administrator has disabled public write access.

Re:SQL query for report builder 4 years 3 months ago #43990

  • Mazi
  • Mazi's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 5325
  • Thank you received: 296
  • Karma: 249
gigipaul wrote:
Hello,
I am also interested in getting the results out of the lime surveys with assessment values, so we can generate reports out of it. Please let me know
Thanks
Gigi
Saving assessment results hasn't been implemented yet. You can vote for this feature here: ideas.limesurvey.org/ideatorrent/idea/7/

To achieve this with current versions you have to code your own script to generate reports.

Best regards/Beste Grüße,
Dr. Marcel Minke
(Limesurvey Head of Support)
Need Help? We offer professional Limesurvey support
Contact: marcel.minke(at)limesurvey.org'"
The administrator has disabled public write access.

Re:SQL query for report builder 3 years 5 months ago #58738

  • laloune
  • laloune's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
Hi,

I am also strong interested in having an sql query to get the result out of the limesurvey mysql db

do you have more information about it ?

I also thought of an API that could generate a csv file that would be then importable into a report builder, any idea ?

thanks in advance,
laloune
The administrator has disabled public write access.

Re:SQL query for report builder 3 years 1 month ago #64569

  • sofos
  • sofos's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 9
  • Karma: 0
Hi, the links dead, and the german xls doesn't work in openoffice :(
The administrator has disabled public write access.

Re: SQL query for report builder 3 years 3 weeks ago #64927

  • plbt5
  • plbt5's Avatar
  • OFFLINE
  • Fresh Lemon
  • Posts: 7
  • Karma: 0
I Have exactly the same question as Snowball here: the need to generically retrieve the data from the database in order to feed it into a data reporting tool.

Thank you in advance
The administrator has disabled public write access.

Re: SQL query for report builder 3 years 3 weeks ago #64936

  • c_schmitz
  • c_schmitz's Avatar
  • OFFLINE
  • LimeSurvey Team
  • Posts: 779
  • Thank you received: 111
  • Karma: 92
There is no way to have a generic statement to retrieve response data.
For each survey the responses table is individually created with individual field names.
What do you need exactly?
Support us, too. Donate to the LimeSurvey project and help keep us going!
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.126 seconds
Donation Image