- Posts: 21
- Thank you received: 0
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
6 years 2 months ago #151336
by driz
Replied by driz on topic Guidance on building a dashboard for one survey - how to access responses
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 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.
6 years 2 months ago - 6 years 2 months ago #151342
by jelo
The meaning of the word "stable" for users
www.limesurvey.org/forum/development/117...ord-stable-for-users
Replied by jelo on topic Guidance on building a dashboard for one survey - how to access responses
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
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: 6 years 2 months ago by jelo.
The topic has been locked.
- DenisChenu
-
- Offline
- LimeSurvey Community Team
-
Less
More
- Posts: 13146
- Thank you received: 2423
6 years 2 months ago #151819
by DenisChenu
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.
Replied by DenisChenu on topic Guidance on building a dashboard for one survey - how to access responses
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
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.