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

TOPIC: SQL query for report builder

SQL query for report builder 4 years 5 months ago #65159

  • c_schmitz
  • c_schmitz's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 918
  • Thank you received: 131
  • Karma: 96
I see. Well, features like that are on our roadmap but do not exist yet. Sorry.
Best regards

Carsten Schmitz
LimeSurvey project leader
The administrator has disabled public write access.

SQL query for report builder 4 years 5 months ago #65161

  • laloune
  • laloune's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 8
  • Karma: 0
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 :))
The administrator has disabled public write access.

SQL query for report builder 1 year 2 months ago #114769

Greetings,


Do you have the mentioned features nowadays?.

Best,
The administrator has disabled public write access.

SQL query for report builder 1 year 2 months ago #114827

  • redman
  • redman's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
I am also very interested in this solution.
The administrator has disabled public write access.

SQL query for report builder 1 year 2 months ago #114831

  • fransmarcelissen
  • fransmarcelissen's Avatar
  • Offline
  • Gold Lime
  • Posts: 232
  • Thank you received: 47
  • Karma: 12
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 administrator has disabled public write access.
The following user(s) said Thank You: Ben_V

SQL query for report builder 5 months 5 days ago #124629

  • kennethli
  • kennethli's Avatar
  • Offline
  • Fresh Lemon
  • Posts: 3
  • Karma: 0
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?
The administrator has disabled public write access.

SQL query for report builder 5 months 4 days ago #124632

  • holch
  • holch's Avatar
  • Offline
  • LimeSurvey Team
  • Posts: 4365
  • Thank you received: 615
  • Karma: 197
No. But with the implementation of the Expression Manager you can do all that you can do with assments and even more.
Have a look at the manual! It is a really valuable source for information. Here some helpful links:
Manual (EN) | Question Types | Question Attributes | Workarounds

If you found this answer helpful and it saved you some time please consider a donation to the project to keep Limesurvey going!
The administrator has disabled public write access.
  • Page:
  • 1
  • 2
Moderators: ITEd
Time to create page: 0.208 seconds