Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Guidance on building a dashboard for one survey - how to access responses

  • driz
  • driz's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
7 years 3 months ago #151336 by driz
A quick update for those interested:

The second part of the column header in the survey responses table is indeed the group ID (gid in the ls_questions table).

The third part either is the question id (qid in the ls_questions table), when the question has no parent_qid. I assume this is the case for full text questions for example, but maybe any question that is not an array and that doesn't have sub-questions.

For those questions that do have multiple sub-questions (e.g. array question), the last part consists of the parent_qid and the "title" (from the ls_questions table). I assume this last bit is the identifier of the sub-question.

Happy to be corrected by anyone in the know, these are just guesses based on the data in my database.
The topic has been locked.
More
7 years 3 months ago - 7 years 3 months ago #151342 by jelo
You might check the old and new database structures here:
manual.limesurvey.org/LimeSurvey_1.8_dat...layout_documentation

There was a newer diagram posted in the Spanish section.
See attachment here:
www.limesurvey.org/forum/spanish-forum/1...ntidad-de-limesurvey

The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Last edit: 7 years 3 months ago by jelo.
The topic has been locked.
  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
7 years 3 months ago #151819 by DenisChenu
About "Response table" : i think it's better to use a 'false' table export with ngood header.

UYou can use export as json or do your own export : framagit.org/SondagePro-LimeSurvey-plugi.../jsonPivotWriter.php for an example

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.

Lime-years ahead

Online-surveys for every purse and purpose