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.

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.

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.

Hi, I answered to your email directly.

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

gigipaul wrote: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.

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

Hi, the links dead, and the german xls doesn't work in openoffice

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

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?