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?

SGQAother in the database.

Just after the answer in the export.

Where did you search it ?

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?

The column just after the "dropdown" column, ending by other

Something like 1234X123X123other

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!

In the SURVEY table:

lime_survey_XXXX where XXXX is the survey number.

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.

Yes that's it.

Raghnarok 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.

In Question object : there are a boolean : other