SQL query for report builder

More
6 years 3 weeks ago #65159 by c_schmitz
c_schmitz replied the topic: SQL query for report builder
I see. Well, features like that are on our roadmap but do not exist yet. Sorry.

Best regards

Carsten Schmitz
LimeSurvey project leader

Please Log in to join the conversation.

More
6 years 3 weeks ago #65161 by laloune
laloune replied the topic: SQL query for report builder

c_schmitz wrote: Hello!

As you already pointed out there is nothing like that in LimeSurvey and there is no way to create such a view yet. I am sorry.


okay thanks for your response

is it also on the roadmap yet ?

if yes I am ok to contribute (for testing for instance :))

Please Log in to join the conversation.

More
2 years 10 months ago #114769 by jcastro2010
jcastro2010 replied the topic: SQL query for report builder
Greetings,


Do you have the mentioned features nowadays?.

Best,

Please Log in to join the conversation.

More
2 years 9 months ago #114827 by redman
redman replied the topic: SQL query for report builder
I am also very interested in this solution.

Please Log in to join the conversation.

More
2 years 9 months ago #114831 by fransmarcelissen
fransmarcelissen replied the topic: SQL query for report builder
Hi,
I do'nt know whether I understand this questions correctly, but until recently I created reports automatically in R and in spss, after reading the database with an simple sql statement. I have created hundreds of reports in this way. This is also possible from spss (and probably also in pspp). The sql statement is simply SELECT * FROM `lime_survey_XXX` where XXX is the survey id. The disadventage of this is that the variable names are SGQ codes (something like 242445X263X2350). Another disadvantage is that in general reading the database is only possible if you are on the server where the database is installed).

Since some time I notices that remotecontrol is much simplier and useful. See manual.limesurvey.org/RemoteControl_2_API#export_responses . Using rc it is possible (for example in R, or php) to read the answers directly in a batch mode, with decent variable names. This data tables can directly be used in R/spss/pspp, or whatever statistical program or report generator you are using.

In my expercience R is much, much more useful than spss.
The following user(s) said Thank You: Ben_V

Please Log in to join the conversation.

More
2 years 2 weeks ago #124629 by kennethli01
kennethli01 replied the topic: SQL query for report builder

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


I have the same requirement of generating reports out of assessment values. Is this a feature available with the current versions?

Please Log in to join the conversation.

More
2 years 2 weeks ago #124632 by holch
holch replied the topic: SQL query for report builder
No. But with the implementation of the Expression Manager you can do all that you can do with assments and even more.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now