Which Table in the Database stores the "Multi answer" values?

More
4 months 2 weeks ago #163256 by LSSSurvey1
LSSSurvey1 created the topic: Which Table in the Database stores the "Multi answer" values?
Hi, i have a survey, one question has a multi answers, which table in the database stores the answers of this question?

For example:
What is your best food
1- Pizza
2- Burger
3- Other, Specify (...............................)

so if somebody checked "Pizza" , where can i find this value in the database? and if somebody checked "Other" and typed "Sushi" where i can find "Sushi" in the database?

Thanks so much for your helps..
i am trying to link a Crystal Report to the database and need the above to accomplish my task..

Please Log in or Create an account to join the conversation.

More
4 months 2 weeks ago #163290 by jelo
jelo replied the topic: Which Table in the Database stores the "Multi answer" values?
The answers from your other thread are still valid.
www.limesurvey.org/community/forums/futu...lyse-the-data#163020

There is one table for every activated survey. Surveyid is used in the tablename.
Depending on the structure of the survey the answers.
You'll have to inspect the database-structure on your own to identify the relevant fields.

Please Log in or Create an account to join the conversation.

More
4 months 2 weeks ago #163302 by LSSSurvey1
LSSSurvey1 replied the topic: Which Table in the Database stores the "Multi answer" values?
Does that mean my data will be stored in xml files instead of the mysql database?

Please Log in or Create an account to join the conversation.

More
4 months 2 weeks ago #163303 by holch
holch replied the topic: Which Table in the Database stores the "Multi answer" values?

Does that mean my data will be stored in xml files instead of the mysql database?

No.

I'm not a LimeSurvey GmbH member. I answer at the LimeSurvey forum in my spare time. No support via private message.
Some helpful links: Manual (EN) | Question Types | Workarounds

Please Log in or Create an account to join the conversation.

More
4 months 2 weeks ago #163310 by jelo
jelo replied the topic: Which Table in the Database stores the "Multi answer" values?

LSSSurvey1 wrote: Does that mean my data will be stored in xml files instead of the mysql database?

It means, that nobody knows in advance, what tablenames and variables names are used till you create the survey and activate it. You need to look inside the mysql database to check for yourself.

Creating the reports will need some tweaks. When you don't change the survey structure, the fields stay the same.
The survey id will be helpful to identify the table of the survey.

Or you use the RemoteControl API. But that means you need to write code to communicate with LimeSurvey.

Please Log in or Create an account to join the conversation.

More
4 months 2 weeks ago #163313 by LSSSurvey1
LSSSurvey1 replied the topic: Which Table in the Database stores the "Multi answer" values?
i understand the process of storing the data in the database, however their are some odd things happening.. for example in my example that i use of the multi answer question i have
what is your favorite food
1- pizza
2- burger
3- other (.................)

i took the survey, and i put "potato" in the "other", however when i search the entire database for a string "potato" , i get 0 result, i am confused of where does this data is stored!?

Please Log in or Create an account to join the conversation.

More
4 months 2 weeks ago #163314 by LSSSurvey1
LSSSurvey1 replied the topic: Which Table in the Database stores the "Multi answer" values?
i found it, it created a new table for that question.. i have now to put the pieces of the puzzle together and create my crystal reports...
thanks very body for all your helps..

Please Log in or Create an account to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!