Hello. Tell me how the sample is implemented when viewing the survey answers, where are the columns displayed by the names that were laid when creating the survey?

if in lime_survey_xxxxxx there would be the same codes as in lime_questions:

lime_questions.parent_qid
lime_questions.title
lime_questions.qid
lime_questions.sid

it was possible to do something in the spirit:

select

from lime_survey_xxxxxx, lime_questions
where
lime_survey_xxxxxx = lime_questions.parent_qid and
lime_survey_xxxxxx = lime_questions.title and
lime_survey_xxxxxx = lime_questions.qid and
lime_survey_xxxxxx = lime_questions.sid

but how is this actually done?

Hi,

Database column names are defined as:

sid-valueXgid-value-Xqid-value, so for example you can have: 998853X2490X44648 or 998853X2492X44652Med1 where 'Med1' is a subquestion of question 44652.
Good luck....!

Thanks