Sql of poll result

More
1 month 1 week ago #160274 by shiva522
shiva522 created the topic: Sql of poll result
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?

Please Log in to join the conversation.

More
1 month 1 week ago #160275 by fvanderstarre
fvanderstarre replied the topic: Sql of poll result
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....!

Please Log in to join the conversation.

More
1 month 6 days ago #160331 by shiva522
shiva522 replied the topic: Sql of poll result
Thanks

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!