Welcome to the LimeSurvey Community Forum

Ask the community, share ideas, and connect with other LimeSurvey users!

Which data model corresponds to the "lime_survey_XXX" database table?

  • hagerregah
  • hagerregah's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
More
3 weeks 4 days ago #264858 by hagerregah
Which data model corresponds to the "lime_survey_XXX" database table? was created by hagerregah
Please help us help you and fill where relevant:
Your LimeSurvey version: 6.5.4
Own server or LimeSurvey hosting:aeonfree
Survey theme/template:Fruity
==================
I am buiding a plugin that displays "long text type" responses.
While I did succeed at pulling the Questions data from the "limesurvey_questions" table ($questions = \Question::model()->findAll("sid = :sid and type = :type", array(":sid" => $surveyId,":type" => 'T'));)
I couldn't find the data model for the "lime_survey_435435", with "435435" being the survey ID.
I tried the "$lesreponses=\Response::model($surveyId)->findAll($question->sid."X".$question->gig."X".$question->qid);" but didn't work.

Thank you in advance

Please Log in to join the conversation.

  • DenisChenu
  • DenisChenu's Avatar
  • Offline
  • LimeSurvey Community Team
  • LimeSurvey Community Team
More
3 weeks 3 days ago #264876 by DenisChenu
Replied by DenisChenu on topic Which data model corresponds to the "lime_survey_XXX" database table?
Response give the response, you want all value of a column

See www.yiiframework.com/doc/api/1.1/CActiveRecord
and
Code:
$lesreponses = \Response::model($surveyId)->findAll();
$column = $question->sid."X".$question->gig."X".$question->qid;
echo "<ul>";
foreach ($lesreponses as $lareponse) {
    echo "<li>" . $lareponse->getAttribute($column) . "</li>";
}
echo "</ul>";
 

 
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.

Please Log in to join the conversation.

Lime-years ahead

Online-surveys for every purse and purpose

Pricing & Plans
Get started

Legal

About Us

Open Source