- Posts: 129
- Thank you received: 6
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Where is the answer to the option "other" of a dropdown list stored?
- mascarpone
- Topic Author
- Offline
- Premium Member
Less
More
8 years 11 months ago #119679
by mascarpone
Where is the answer to the option "other" of a dropdown list stored? was created by mascarpone
I have used a dropdown with the option "other" for which a text answer has to be submitted mandatorily.
I can not find where the answer to that text field is stored.
Any idea?
I can not find where the answer to that text field is stored.
Any idea?
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
8 years 11 months ago #119684
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 Where is the answer to the option "other" of a dropdown list stored?
SGQAother in the database.
Just after the answer in the export.
Where did you search it ?
Just after the answer in the export.
Where did you search it ?
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.
- mascarpone
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 129
- Thank you received: 6
8 years 11 months ago #119708
by mascarpone
Replied by mascarpone on topic Where is the answer to the option "other" of a dropdown list stored?
Thanks Denis,
I can indeed see it displayed in the export or in the view of results but I can not locate it in the mysql db (I'd need to locate it as we are pluging a report to the Db direclty)
Any idea where it sits?
I can indeed see it displayed in the export or in the view of results but I can not locate it in the mysql db (I'd need to locate it as we are pluging a report to the Db direclty)
Any idea where it sits?
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
8 years 11 months ago #119709
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 Where is the answer to the option "other" of a dropdown list stored?
The column just after the "dropdown" column, ending by other
Something like 1234X123X123other
Something like 1234X123X123other
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 following user(s) said Thank You: mascarpone
The topic has been locked.
- mascarpone
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 129
- Thank you received: 6
8 years 11 months ago #119711
by mascarpone
Replied by mascarpone on topic Where is the answer to the option "other" of a dropdown list stored?
Yes I can see that in my response view and in the exports, but when I look for that question code throughout my MySQL DB I can't find it?
I thought this would be stored in lime_questions, but can't seem to find it - same for other tables.
Will go for a third coffea (having a harsh start today...)
Thanks for your patience Denis!
I thought this would be stored in lime_questions, but can't seem to find it - same for other tables.
Will go for a third coffea (having a harsh start today...)
Thanks for your patience Denis!
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
8 years 11 months ago #119714
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 Where is the answer to the option "other" of a dropdown list stored?
In the SURVEY table:
lime_survey_XXXX where XXXX is the survey number.
lime_survey_XXXX where XXXX is the survey number.
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 following user(s) said Thank You: mascarpone
The topic has been locked.
- Raghnarok
- Offline
- New Member
Less
More
- Posts: 1
- Thank you received: 1
8 years 11 months ago - 8 years 11 months ago #119715
by Raghnarok
Replied by Raghnarok on topic Where is the answer to the option "other" of a dropdown list stored?
I'm entering here, I'm working with mas_carpone and I'm the one who can't find the question.
Denis, are you saying that for this kind of dropdown question, the "other" answer will always be on ...X...X...other in the table lime_survey_XXXX? If so, that's easy for me to pickup this additionnal answer.
Thanks for your answer and your time.
P.S.: Of course I know the question is in the lime_survey_XXXX table, I didn't knew that this is all the same "object" for you, so if it is I understand why there is no entry in the lime_questions table.
Denis, are you saying that for this kind of dropdown question, the "other" answer will always be on ...X...X...other in the table lime_survey_XXXX? If so, that's easy for me to pickup this additionnal answer.
Thanks for your answer and your time.
P.S.: Of course I know the question is in the lime_survey_XXXX table, I didn't knew that this is all the same "object" for you, so if it is I understand why there is no entry in the lime_questions table.
Last edit: 8 years 11 months ago by Raghnarok.
The following user(s) said Thank You: mascarpone
The topic has been locked.
- mascarpone
- Topic Author
- Offline
- Premium Member
Less
More
- Posts: 129
- Thank you received: 6
8 years 11 months ago #119801
by mascarpone
Replied by mascarpone on topic Where is the answer to the option "other" of a dropdown list stored?
Yes that's it.
The topic has been locked.
- DenisChenu
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 13597
- Thank you received: 2487
8 years 11 months ago #119803
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 Where is the answer to the option "other" of a dropdown list stored?
In Question object : there are a boolean : otherRaghnarok wrote: P.S.: Of course I know the question is in the lime_survey_XXXX table, I didn't knew that this is all the same "object" for you, so if it is I understand why there is no entry in the lime_questions table.
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 following user(s) said Thank You: mascarpone
The topic has been locked.