View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
17829Bug reportsOtherpublic2022-02-23 10:35
ReporterDenisChenu Assigned Togalads  
PrioritynoneSeverityminor 
Status confirmedResolutionopen 
Product Version5.2.x 
Summary17829: findAll return only one record
Description

using findAll with QuestionAttribute model return only one record.

Steps To Reproduce

Steps to reproduce

  1. Activate debug mode
  2. Import included plugin (pdfReport)
  3. Import included survey
  4. Activate
  5. Launch : check the tracevar to 1
  6. Only one pdf generated
  7. Do the same with 3.X (last one)
  8. tracevar show 2 and 2 pdf are generated

Expected result

tracevar show 2 and 2 pdf are generated

Actual result

tracevar show 1 and 1 pdf are generated

TagsNo tags attached.
Attached Files
pdfReport.zip (486,946 bytes)
limesurvey_survey_476956.lss (42,089 bytes)   
<?xml version="1.0" encoding="UTF-8"?>
<document>
 <LimeSurveyDocType>Survey</LimeSurveyDocType>
 <DBVersion>365</DBVersion>
 <languages>
  <language>en</language>
 </languages>
 <answers>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>code</fieldname>
   <fieldname>answer</fieldname>
   <fieldname>sortorder</fieldname>
   <fieldname>assessment_value</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[6045]]></qid>
    <code><![CDATA[ARCH]]></code>
    <answer><![CDATA[<img src="{SURVEYRESOURCESURL}files/archlinux-logo.png" alt="ArcLinux" />]]></answer>
    <sortorder><![CDATA[5]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[6045]]></qid>
    <code><![CDATA[DEB]]></code>
    <answer><![CDATA[<img src="{SURVEYRESOURCESURL}files/debian-logo.png" alt="Debian" />]]></answer>
    <sortorder><![CDATA[1]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[6045]]></qid>
    <code><![CDATA[FEDO]]></code>
    <answer><![CDATA[<img src="{SURVEYRESOURCESURL}files/fedora-logo.png" alt="Fedora" />]]></answer>
    <sortorder><![CDATA[2]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[6045]]></qid>
    <code><![CDATA[SLACK]]></code>
    <answer><![CDATA[<img src="{SURVEYRESOURCESURL}files/slackware-logo.png" alt="Slack" />]]></answer>
    <sortorder><![CDATA[3]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
   <row>
    <qid><![CDATA[6045]]></qid>
    <code><![CDATA[SUSE]]></code>
    <answer><![CDATA[<img src="{SURVEYRESOURCESURL}files/suse-logo.png" alt="Suse" />]]></answer>
    <sortorder><![CDATA[4]]></sortorder>
    <assessment_value><![CDATA[0]]></assessment_value>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
   </row>
  </rows>
 </answers>
 <groups>
  <fields>
   <fieldname>gid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>group_name</fieldname>
   <fieldname>group_order</fieldname>
   <fieldname>description</fieldname>
   <fieldname>language</fieldname>
   <fieldname>randomization_group</fieldname>
   <fieldname>grelevance</fieldname>
  </fields>
  <rows>
   <row>
    <gid><![CDATA[388]]></gid>
    <sid><![CDATA[476956]]></sid>
    <group_name><![CDATA[Prefilling]]></group_name>
    <group_order><![CDATA[1]]></group_order>
    <description/>
    <language><![CDATA[en]]></language>
    <randomization_group/>
    <grelevance/>
   </row>
   <row>
    <gid><![CDATA[389]]></gid>
    <sid><![CDATA[476956]]></sid>
    <group_name><![CDATA[The Linux distributions logos]]></group_name>
    <group_order><![CDATA[2]]></group_order>
    <description/>
    <language><![CDATA[en]]></language>
    <randomization_group/>
    <grelevance/>
   </row>
   <row>
    <gid><![CDATA[390]]></gid>
    <sid><![CDATA[476956]]></sid>
    <group_name><![CDATA[Report]]></group_name>
    <group_order><![CDATA[4]]></group_order>
    <description/>
    <language><![CDATA[en]]></language>
    <randomization_group/>
    <grelevance/>
   </row>
   <row>
    <gid><![CDATA[391]]></gid>
    <sid><![CDATA[476956]]></sid>
    <group_name><![CDATA[Hicdden Report]]></group_name>
    <group_order><![CDATA[3]]></group_order>
    <description/>
    <language><![CDATA[en]]></language>
    <randomization_group/>
    <grelevance/>
   </row>
  </rows>
 </groups>
 <questions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_qid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>type</fieldname>
   <fieldname>title</fieldname>
   <fieldname>question</fieldname>
   <fieldname>preg</fieldname>
   <fieldname>help</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[6043]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[476956]]></sid>
    <gid><![CDATA[388]]></gid>
    <type><![CDATA[Q]]></type>
    <title><![CDATA[USER]]></title>
    <question><![CDATA[Tell me who you are. If you put a valid email : you receive a PDF with the report.]]></question>
    <preg/>
    <help><![CDATA[{if(is_empty(USER_EMAIL.NAOK),"<div class='error'>If you leave email empty, you don&apos;t get the report.</div>","")}
{if(!is_empty(USER_EMAIL.NAOK) && !regexMatch("/^(\w[-._+\w]*\w@\w[-._\w]*\w\.\w{2,})?$/",USER_EMAIL.NAOK),"<div class='warning'>Are you sure your email is valid ?</div>","")}
{if(!is_empty(USER_EMAIL.NAOK) && regexMatch("/^(\w[-._+\w]*\w@\w[-._\w]*\w\.\w{2,})?$/",USER_EMAIL.NAOK),"<div class='good'>Your email seems valid, we send the PDF report.</div>","")}
<div class="alert alert-warning">Email is deactivated on this instance</div>]]></help>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[0]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[6044]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[476956]]></sid>
    <gid><![CDATA[389]]></gid>
    <type><![CDATA[M]]></type>
    <title><![CDATA[KnowUse]]></title>
    <question><![CDATA[Did you use or know this ditributions]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[0]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[6045]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[476956]]></sid>
    <gid><![CDATA[389]]></gid>
    <type><![CDATA[R]]></type>
    <title><![CDATA[Best]]></title>
    <question><![CDATA[What distribution you using most]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[count(that.KnowUse.NAOK) > 1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[6046]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[476956]]></sid>
    <gid><![CDATA[390]]></gid>
    <type><![CDATA[X]]></type>
    <title><![CDATA[Information]]></title>
    <question><![CDATA[Here : we construct the report. This question can be hidden, you can use html, expression manager. The report file use the question text.]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[0]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[6047]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[476956]]></sid>
    <gid><![CDATA[390]]></gid>
    <type><![CDATA[|]]></type>
    <title><![CDATA[Report]]></title>
    <question><![CDATA[<h1>
	Here is your report</h1>
<p>
	Hi {USER_NAME.NAOK},</p>
<p>
	You know {count(that.KnowUse.NAOK)} linux distribution on the list.</p>
{if(is_empty(Best_1.NAOK),"<p>	You don't rank any of this distribution</p>","<p>The distribution you use the most are "+Best_1.shown+"</p>")}
<h2 style="text-align:center">
	Some style usage</h2>
<p style="text-align: right;">
	Text align : right</p>
<ol>
	<li style="text-align: right;">
		A ordered list</li>
	<li style="text-align: right;">
		With 3 elements</li>
	<li style="text-align: right;">
		The 3rd element</li>
</ol>
<p>
	Some link : <a href="http://extensions.sondages.pro/about/contact.html">Get support for this plugin</a><br />
	or <a href="https://framagit.org/SondagePro-LimeSurvey-plugin/pdfReport">fork it</a>, use it, adapt it, distribute it; because <strong><a href="https://www.gnu.org/licenses/agpl.html"><span style="color:#B22222;">you are free to do it</span></a></strong>.</p>
<p>
	Long line can have issue , best is to use <br> or to use only short line :</p>
<p>
	Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec dui nunc, faucibus ac neque in, gravida sollicitudin nunc. Phasellus venenatis nunc et eros pretium sodales quis sit amet enim. Morbi in dapibus elit. Quisque sit amet ornare quam, sed aliquet lectus. Quisque finibus facilisis erat, sit amet sagittis lorem. Aliquam erat volutpat. Cras pretium ultrices risus, suscipit vestibulum odio vehicula semper.</p>
<br pagebreak="true" />
<h1>
	A new page is here</h1>
<h2>
	image width is set in cm</h2>
<p>
	<img alt="gnu and penguin" src="/3LTS/upload/surveys/476956/images/gnu-and-penguin-color-1024x946.jpg"  style="width: 18cm; height: auto;"/></p>
<p>
	<em>Better to use internal files than external dur to downloading files</em></p>
<h2>
	A broken image</h2>
<p>
	<img alt="broken image " src="invalid.png" style="width: 18cm; height: auto;" /></p>
<p>
	After the image</p>
]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[6055]]></qid>
    <parent_qid><![CDATA[0]]></parent_qid>
    <sid><![CDATA[476956]]></sid>
    <gid><![CDATA[391]]></gid>
    <type><![CDATA[|]]></type>
    <title><![CDATA[HiddenReport]]></title>
    <question><![CDATA[<h1>
	Hidden report</h1>
<p>
	Hi {USER_NAME.NAOK},</p>
<p>]]></question>
    <preg/>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[0]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
  </rows>
 </questions>
 <subquestions>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>parent_qid</fieldname>
   <fieldname>sid</fieldname>
   <fieldname>gid</fieldname>
   <fieldname>type</fieldname>
   <fieldname>title</fieldname>
   <fieldname>question</fieldname>
   <fieldname>preg</fieldname>
   <fieldname>help</fieldname>
   <fieldname>other</fieldname>
   <fieldname>mandatory</fieldname>
   <fieldname>question_order</fieldname>
   <fieldname>language</fieldname>
   <fieldname>scale_id</fieldname>
   <fieldname>same_default</fieldname>
   <fieldname>relevance</fieldname>
   <fieldname>modulename</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[6048]]></qid>
    <parent_qid><![CDATA[6043]]></parent_qid>
    <sid><![CDATA[476956]]></sid>
    <gid><![CDATA[388]]></gid>
    <type><![CDATA[Q]]></type>
    <title><![CDATA[NAME]]></title>
    <question><![CDATA[Your name]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[6049]]></qid>
    <parent_qid><![CDATA[6043]]></parent_qid>
    <sid><![CDATA[476956]]></sid>
    <gid><![CDATA[388]]></gid>
    <type><![CDATA[Q]]></type>
    <title><![CDATA[EMAIL]]></title>
    <question><![CDATA[Your email]]></question>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance/>
    <modulename/>
   </row>
   <row>
    <qid><![CDATA[6050]]></qid>
    <parent_qid><![CDATA[6044]]></parent_qid>
    <sid><![CDATA[476956]]></sid>
    <gid><![CDATA[389]]></gid>
    <type><![CDATA[M]]></type>
    <title><![CDATA[DEB]]></title>
    <question><![CDATA[<img src="{SURVEYRESOURCESURL}files/debian-logo.png" alt="Debian" />]]></question>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[1]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[6051]]></qid>
    <parent_qid><![CDATA[6044]]></parent_qid>
    <sid><![CDATA[476956]]></sid>
    <gid><![CDATA[389]]></gid>
    <type><![CDATA[M]]></type>
    <title><![CDATA[FEDO]]></title>
    <question><![CDATA[<img src="{SURVEYRESOURCESURL}files/fedora-logo.png" alt="Fedora" />]]></question>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[2]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[6052]]></qid>
    <parent_qid><![CDATA[6044]]></parent_qid>
    <sid><![CDATA[476956]]></sid>
    <gid><![CDATA[389]]></gid>
    <type><![CDATA[M]]></type>
    <title><![CDATA[SLACK]]></title>
    <question><![CDATA[<img src="{SURVEYRESOURCESURL}files/slackware-logo.png" alt="Slack" />]]></question>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[3]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[6053]]></qid>
    <parent_qid><![CDATA[6044]]></parent_qid>
    <sid><![CDATA[476956]]></sid>
    <gid><![CDATA[389]]></gid>
    <type><![CDATA[M]]></type>
    <title><![CDATA[SUSE]]></title>
    <question><![CDATA[<img src="{SURVEYRESOURCESURL}files/suse-logo.png" alt="Suse" />]]></question>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[4]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
   <row>
    <qid><![CDATA[6054]]></qid>
    <parent_qid><![CDATA[6044]]></parent_qid>
    <sid><![CDATA[476956]]></sid>
    <gid><![CDATA[389]]></gid>
    <type><![CDATA[M]]></type>
    <title><![CDATA[ARCH]]></title>
    <question><![CDATA[<img src="{SURVEYRESOURCESURL}files/archlinux-logo.png" alt="ArcLinux" />]]></question>
    <help/>
    <other><![CDATA[N]]></other>
    <mandatory><![CDATA[N]]></mandatory>
    <question_order><![CDATA[5]]></question_order>
    <language><![CDATA[en]]></language>
    <scale_id><![CDATA[0]]></scale_id>
    <same_default><![CDATA[0]]></same_default>
    <relevance><![CDATA[1]]></relevance>
   </row>
  </rows>
 </subquestions>
 <question_attributes>
  <fields>
   <fieldname>qid</fieldname>
   <fieldname>attribute</fieldname>
   <fieldname>value</fieldname>
   <fieldname>language</fieldname>
  </fields>
  <rows>
   <row>
    <qid><![CDATA[6044]]></qid>
    <attribute><![CDATA[random_order]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qid><![CDATA[6045]]></qid>
    <attribute><![CDATA[array_filter]]></attribute>
    <value><![CDATA[KnowUse]]></value>
   </row>
   <row>
    <qid><![CDATA[6045]]></qid>
    <attribute><![CDATA[max_subquestions]]></attribute>
    <value><![CDATA[5]]></value>
   </row>
   <row>
    <qid><![CDATA[6047]]></qid>
    <attribute><![CDATA[pdfReport]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qid><![CDATA[6047]]></qid>
    <attribute><![CDATA[pdfReportPdfGenerator]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qid><![CDATA[6047]]></qid>
    <attribute><![CDATA[pdfReportPrintAnswer]]></attribute>
    <value><![CDATA[2]]></value>
   </row>
   <row>
    <qid><![CDATA[6047]]></qid>
    <attribute><![CDATA[pdfReportSavedFileName]]></attribute>
    <value><![CDATA[PDF-Report-Sample]]></value>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <qid><![CDATA[6047]]></qid>
    <attribute><![CDATA[pdfReportSendByEmailContent]]></attribute>
    <value><![CDATA[confirm]]></value>
   </row>
   <row>
    <qid><![CDATA[6047]]></qid>
    <attribute><![CDATA[pdfReportSendByEmailMail]]></attribute>
    <value><![CDATA[{USER_EMAIL}]]></value>
   </row>
   <row>
    <qid><![CDATA[6047]]></qid>
    <attribute><![CDATA[pdfReportSubTitle]]></attribute>
    <value><![CDATA[{SURVEYNAME}]]></value>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <qid><![CDATA[6047]]></qid>
    <attribute><![CDATA[pdfReportTitle]]></attribute>
    <value><![CDATA[{SITENAME}]]></value>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <qid><![CDATA[6055]]></qid>
    <attribute><![CDATA[pdfReport]]></attribute>
    <value><![CDATA[1]]></value>
   </row>
   <row>
    <qid><![CDATA[6055]]></qid>
    <attribute><![CDATA[pdfReportPdfGenerator]]></attribute>
    <value><![CDATA[0]]></value>
   </row>
   <row>
    <qid><![CDATA[6055]]></qid>
    <attribute><![CDATA[pdfReportPrintAnswer]]></attribute>
    <value><![CDATA[2]]></value>
   </row>
   <row>
    <qid><![CDATA[6055]]></qid>
    <attribute><![CDATA[pdfReportSavedFileName]]></attribute>
    <value><![CDATA[PDF-Report-Sample]]></value>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <qid><![CDATA[6055]]></qid>
    <attribute><![CDATA[pdfReportSendByEmailContent]]></attribute>
    <value><![CDATA[confirm]]></value>
   </row>
   <row>
    <qid><![CDATA[6055]]></qid>
    <attribute><![CDATA[pdfReportSendByEmailMail]]></attribute>
    <value><![CDATA[{USER_EMAIL}]]></value>
   </row>
   <row>
    <qid><![CDATA[6055]]></qid>
    <attribute><![CDATA[pdfReportSubTitle]]></attribute>
    <value><![CDATA[{SURVEYNAME}]]></value>
    <language><![CDATA[en]]></language>
   </row>
   <row>
    <qid><![CDATA[6055]]></qid>
    <attribute><![CDATA[pdfReportTitle]]></attribute>
    <value><![CDATA[{SITENAME}]]></value>
    <language><![CDATA[en]]></language>
   </row>
  </rows>
 </question_attributes>
 <surveys>
  <fields>
   <fieldname>sid</fieldname>
   <fieldname>gsid</fieldname>
   <fieldname>admin</fieldname>
   <fieldname>expires</fieldname>
   <fieldname>startdate</fieldname>
   <fieldname>adminemail</fieldname>
   <fieldname>anonymized</fieldname>
   <fieldname>faxto</fieldname>
   <fieldname>format</fieldname>
   <fieldname>savetimings</fieldname>
   <fieldname>template</fieldname>
   <fieldname>language</fieldname>
   <fieldname>additional_languages</fieldname>
   <fieldname>datestamp</fieldname>
   <fieldname>usecookie</fieldname>
   <fieldname>allowregister</fieldname>
   <fieldname>allowsave</fieldname>
   <fieldname>autonumber_start</fieldname>
   <fieldname>autoredirect</fieldname>
   <fieldname>allowprev</fieldname>
   <fieldname>printanswers</fieldname>
   <fieldname>ipaddr</fieldname>
   <fieldname>refurl</fieldname>
   <fieldname>showsurveypolicynotice</fieldname>
   <fieldname>publicstatistics</fieldname>
   <fieldname>publicgraphs</fieldname>
   <fieldname>listpublic</fieldname>
   <fieldname>htmlemail</fieldname>
   <fieldname>sendconfirmation</fieldname>
   <fieldname>tokenanswerspersistence</fieldname>
   <fieldname>assessments</fieldname>
   <fieldname>usecaptcha</fieldname>
   <fieldname>usetokens</fieldname>
   <fieldname>bounce_email</fieldname>
   <fieldname>attributedescriptions</fieldname>
   <fieldname>emailresponseto</fieldname>
   <fieldname>emailnotificationto</fieldname>
   <fieldname>tokenlength</fieldname>
   <fieldname>showxquestions</fieldname>
   <fieldname>showgroupinfo</fieldname>
   <fieldname>shownoanswer</fieldname>
   <fieldname>showqnumcode</fieldname>
   <fieldname>bouncetime</fieldname>
   <fieldname>bounceprocessing</fieldname>
   <fieldname>bounceaccounttype</fieldname>
   <fieldname>bounceaccounthost</fieldname>
   <fieldname>bounceaccountpass</fieldname>
   <fieldname>bounceaccountencryption</fieldname>
   <fieldname>bounceaccountuser</fieldname>
   <fieldname>showwelcome</fieldname>
   <fieldname>showprogress</fieldname>
   <fieldname>questionindex</fieldname>
   <fieldname>navigationdelay</fieldname>
   <fieldname>nokeyboard</fieldname>
   <fieldname>alloweditaftercompletion</fieldname>
   <fieldname>googleanalyticsstyle</fieldname>
   <fieldname>googleanalyticsapikey</fieldname>
  </fields>
  <rows>
   <row>
    <sid><![CDATA[476956]]></sid>
    <gsid><![CDATA[1]]></gsid>
    <admin><![CDATA[Denis Chenu]]></admin>
    <adminemail><![CDATA[denis@sondages.pro]]></adminemail>
    <anonymized><![CDATA[Y]]></anonymized>
    <faxto/>
    <format><![CDATA[G]]></format>
    <savetimings><![CDATA[N]]></savetimings>
    <template><![CDATA[skelvanilla]]></template>
    <language><![CDATA[en]]></language>
    <additional_languages/>
    <datestamp><![CDATA[N]]></datestamp>
    <usecookie><![CDATA[N]]></usecookie>
    <allowregister><![CDATA[N]]></allowregister>
    <allowsave><![CDATA[Y]]></allowsave>
    <autonumber_start><![CDATA[6]]></autonumber_start>
    <autoredirect><![CDATA[N]]></autoredirect>
    <allowprev><![CDATA[Y]]></allowprev>
    <printanswers><![CDATA[Y]]></printanswers>
    <ipaddr><![CDATA[N]]></ipaddr>
    <refurl><![CDATA[N]]></refurl>
    <showsurveypolicynotice><![CDATA[0]]></showsurveypolicynotice>
    <publicstatistics><![CDATA[N]]></publicstatistics>
    <publicgraphs><![CDATA[N]]></publicgraphs>
    <listpublic><![CDATA[Y]]></listpublic>
    <htmlemail><![CDATA[Y]]></htmlemail>
    <sendconfirmation><![CDATA[Y]]></sendconfirmation>
    <tokenanswerspersistence><![CDATA[N]]></tokenanswerspersistence>
    <assessments><![CDATA[N]]></assessments>
    <usecaptcha><![CDATA[N]]></usecaptcha>
    <usetokens><![CDATA[N]]></usetokens>
    <bounce_email><![CDATA[denis@sondages.pro]]></bounce_email>
    <emailresponseto/>
    <emailnotificationto><![CDATA[{USER_EMAIL.NAOK}]]></emailnotificationto>
    <tokenlength><![CDATA[15]]></tokenlength>
    <showxquestions><![CDATA[Y]]></showxquestions>
    <showgroupinfo><![CDATA[B]]></showgroupinfo>
    <shownoanswer><![CDATA[Y]]></shownoanswer>
    <showqnumcode><![CDATA[X]]></showqnumcode>
    <bounceprocessing><![CDATA[N]]></bounceprocessing>
    <showwelcome><![CDATA[N]]></showwelcome>
    <showprogress><![CDATA[Y]]></showprogress>
    <questionindex><![CDATA[2]]></questionindex>
    <navigationdelay><![CDATA[0]]></navigationdelay>
    <nokeyboard><![CDATA[N]]></nokeyboard>
    <alloweditaftercompletion><![CDATA[N]]></alloweditaftercompletion>
    <googleanalyticsstyle><![CDATA[0]]></googleanalyticsstyle>
    <googleanalyticsapikey/>
   </row>
  </rows>
 </surveys>
 <surveys_languagesettings>
  <fields>
   <fieldname>surveyls_survey_id</fieldname>
   <fieldname>surveyls_language</fieldname>
   <fieldname>surveyls_title</fieldname>
   <fieldname>surveyls_description</fieldname>
   <fieldname>surveyls_welcometext</fieldname>
   <fieldname>surveyls_endtext</fieldname>
   <fieldname>surveyls_policy_notice</fieldname>
   <fieldname>surveyls_policy_error</fieldname>
   <fieldname>surveyls_policy_notice_label</fieldname>
   <fieldname>surveyls_url</fieldname>
   <fieldname>surveyls_urldescription</fieldname>
   <fieldname>surveyls_email_invite_subj</fieldname>
   <fieldname>surveyls_email_invite</fieldname>
   <fieldname>surveyls_email_remind_subj</fieldname>
   <fieldname>surveyls_email_remind</fieldname>
   <fieldname>surveyls_email_register_subj</fieldname>
   <fieldname>surveyls_email_register</fieldname>
   <fieldname>surveyls_email_confirm_subj</fieldname>
   <fieldname>surveyls_email_confirm</fieldname>
   <fieldname>surveyls_dateformat</fieldname>
   <fieldname>surveyls_attributecaptions</fieldname>
   <fieldname>email_admin_notification_subj</fieldname>
   <fieldname>email_admin_notification</fieldname>
   <fieldname>email_admin_responses_subj</fieldname>
   <fieldname>email_admin_responses</fieldname>
   <fieldname>surveyls_numberformat</fieldname>
   <fieldname>attachments</fieldname>
  </fields>
  <rows>
   <row>
    <surveyls_survey_id><![CDATA[476956]]></surveyls_survey_id>
    <surveyls_language><![CDATA[en]]></surveyls_language>
    <surveyls_title><![CDATA[pdfReport test survey]]></surveyls_title>
    <surveyls_description><![CDATA[The pdfReport test survey]]></surveyls_description>
    <surveyls_welcometext/>
    <surveyls_endtext><![CDATA[<p>
	{if(is_empty(USER_EMAIL.NAOK),"You don't put any email, we can not send you the example pdf.","The server send you an email with the pdf, see you mailbox.")}</p>
<p>
	You can download this survey : <a charset="utf8" href="/upload/surveys/{SID}/files/limesurvey_survey_sendPdReport.lss" lang="en" target="_blank" type="text/xml">limesurvey_survey_sendPdReport.lss</a> (without this link). But remind : the picture must be uploaded to your survey too.</p>
]]></surveyls_endtext>
    <surveyls_url/>
    <surveyls_urldescription/>
    <surveyls_email_invite_subj><![CDATA[Invitation to participate in a survey]]></surveyls_email_invite_subj>
    <surveyls_email_invite><![CDATA[Dear {FIRSTNAME},<br />
<br />
you have been invited to participate in a survey.<br />
<br />
The survey is titled:<br />
"{SURVEYNAME}"<br />
<br />
"{SURVEYDESCRIPTION}"<br />
<br />
To participate, please click on the link below.<br />
<br />
Sincerely,<br />
<br />
{ADMINNAME} ({ADMINEMAIL})<br />
<br />
----------------------------------------------<br />
Click here to do the survey:<br />
{SURVEYURL}<br />
<br />
If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br />
{OPTOUTURL}<br />
<br />
If you are blacklisted but want to participate in this survey and want to receive invitations please click the following link:<br />
{OPTINURL}]]></surveyls_email_invite>
    <surveyls_email_remind_subj><![CDATA[Reminder to participate in a survey]]></surveyls_email_remind_subj>
    <surveyls_email_remind><![CDATA[Dear {FIRSTNAME},<br />
<br />
Recently we invited you to participate in a survey.<br />
<br />
We note that you have not yet completed the survey, and wish to remind you that the survey is still available should you wish to take part.<br />
<br />
The survey is titled:<br />
"{SURVEYNAME}"<br />
<br />
"{SURVEYDESCRIPTION}"<br />
<br />
To participate, please click on the link below.<br />
<br />
Sincerely,<br />
<br />
{ADMINNAME} ({ADMINEMAIL})<br />
<br />
----------------------------------------------<br />
Click here to do the survey:<br />
{SURVEYURL}<br />
<br />
If you do not want to participate in this survey and don't want to receive any more invitations please click the following link:<br />
{OPTOUTURL}]]></surveyls_email_remind>
    <surveyls_email_register_subj><![CDATA[Survey registration confirmation]]></surveyls_email_register_subj>
    <surveyls_email_register><![CDATA[Dear {FIRSTNAME},<br />
<br />
You, or someone using your email address, have registered to participate in an online survey titled {SURVEYNAME}.<br />
<br />
To complete this survey, click on the following URL:<br />
<br />
{SURVEYURL}<br />
<br />
If you have any questions about this survey, or if you did not register to participate and believe this email is in error, please contact {ADMINNAME} at {ADMINEMAIL}.]]></surveyls_email_register>
    <surveyls_email_confirm_subj><![CDATA[Confirmation of your participation in our survey]]></surveyls_email_confirm_subj>
    <surveyls_email_confirm><![CDATA[Dear {USER_NAME.NAOK},<br />
<br />
this email is to confirm that you have completed the survey titled {SURVEYNAME} and your response has been saved. Thank you for participating.<br />
<br />
Please find the your report as an attachment.<br />
<br />
{Report.question}
<br/>
Sincerely,<br />
<br />
{ADMINNAME}]]></surveyls_email_confirm>
    <surveyls_dateformat><![CDATA[9]]></surveyls_dateformat>
    <email_admin_notification_subj><![CDATA[Response submission for survey {SURVEYNAME}]]></email_admin_notification_subj>
    <email_admin_notification><![CDATA[Hello,<br />
<br />
A new response was submitted for your survey '{SURVEYNAME}'.<br />
<br />
{Report.question}
<br />
View statistics by clicking here:<br />
{STATISTICSURL}]]></email_admin_notification>
    <email_admin_responses_subj><![CDATA[Response submission for survey {SURVEYNAME} with results]]></email_admin_responses_subj>
    <email_admin_responses><![CDATA[Hello,<br />
<br />
A new response was submitted for your survey '{SURVEYNAME}'.<br />
<br />
Click the following link to reload the survey:<br />
{RELOADURL}<br />
<br />
Click the following link to see the individual response:<br />
{VIEWRESPONSEURL}<br />
<br />
Click the following link to edit the individual response:<br />
{EDITRESPONSEURL}<br />
<br />
View statistics by clicking here:<br />
{STATISTICSURL}<br />
<br />
<br />
The following answers were given by the participant:<br />
{ANSWERTABLE}]]></email_admin_responses>
    <surveyls_numberformat><![CDATA[0]]></surveyls_numberformat>
    <attachments><![CDATA[a:0:{}]]></attachments>
   </row>
  </rows>
 </surveys_languagesettings>
 <plugin_settings>
  <fields>
   <fieldname>id</fieldname>
   <fieldname>name</fieldname>
   <fieldname>key</fieldname>
   <fieldname>value</fieldname>
  </fields>
  <rows>
   <row>
    <id><![CDATA[2443]]></id>
    <name><![CDATA[quickStatAdminParticipationAndStat]]></name>
    <key><![CDATA[questionCrossSatisfactionTable]]></key>
    <value><![CDATA[null]]></value>
   </row>
   <row>
    <id><![CDATA[2442]]></id>
    <name><![CDATA[quickStatAdminParticipationAndStat]]></name>
    <key><![CDATA[questionCrossSatisfaction]]></key>
    <value><![CDATA[null]]></value>
   </row>
   <row>
    <id><![CDATA[2441]]></id>
    <name><![CDATA[quickStatAdminParticipationAndStat]]></name>
    <key><![CDATA[tokenAttributesSatisfaction]]></key>
    <value><![CDATA[null]]></value>
   </row>
   <row>
    <id><![CDATA[2440]]></id>
    <name><![CDATA[quickStatAdminParticipationAndStat]]></name>
    <key><![CDATA[questionNumeric]]></key>
    <value><![CDATA[null]]></value>
   </row>
   <row>
    <id><![CDATA[2439]]></id>
    <name><![CDATA[quickStatAdminParticipationAndStat]]></name>
    <key><![CDATA[questionCross]]></key>
    <value><![CDATA[null]]></value>
   </row>
   <row>
    <id><![CDATA[2438]]></id>
    <name><![CDATA[quickStatAdminParticipationAndStat]]></name>
    <key><![CDATA[tokenAttributes]]></key>
    <value><![CDATA[null]]></value>
   </row>
   <row>
    <id><![CDATA[2437]]></id>
    <name><![CDATA[quickStatAdminParticipationAndStat]]></name>
    <key><![CDATA[numberMax]]></key>
    <value><![CDATA["0"]]></value>
   </row>
   <row>
    <id><![CDATA[2436]]></id>
    <name><![CDATA[quickStatAdminParticipationAndStat]]></name>
    <key><![CDATA[alternateTitle]]></key>
    <value><![CDATA[""]]></value>
   </row>
   <row>
    <id><![CDATA[2435]]></id>
    <name><![CDATA[findUserAgentInfo]]></name>
    <key><![CDATA[active]]></key>
    <value><![CDATA[""]]></value>
   </row>
  </rows>
 </plugin_settings>
 <themes>
  <theme>
   <sid>476956</sid>
   <template_name>skelvanilla</template_name>
   <config>
    <options>
     <general_inherit>1</general_inherit>
     <fixnumauto>inherit</fixnumauto>
     <theme>css/variations/contrast-awesome.min.css</theme>
     <questionsize>inherit</questionsize>
     <questioncolor>inherit</questioncolor>
     <questionwrap>inherit</questionwrap>
     <helpcolor>inherit</helpcolor>
     <validitycolor>inherit</validitycolor>
     <descriptiondisplay>inherit</descriptiondisplay>
     <titlelocation>inherit</titlelocation>
     <brandlogofile>inherit</brandlogofile>
     <surveylistlogofile>inherit</surveylistlogofile>
     <poweredlogofile>inherit</poweredlogofile>
     <hideprivacyinfo>inherit</hideprivacyinfo>
     <showpopups>inherit</showpopups>
     <questionhtag>inherit</questionhtag>
     <removeback>inherit</removeback>
     <dynamicvalidity>inherit</dynamicvalidity>
     <showclearall>inherit</showclearall>
     <tableheader>inherit</tableheader>
     <savelink>inherit</savelink>
     <clearalllink>inherit</clearalllink>
     <indexlink>inherit</indexlink>
     <languagelink>inherit</languagelink>
     <previouslink>inherit</previouslink>
     <nextsubmitlink>inherit</nextsubmitlink>
     <container>inherit</container>
     <headercontainer>inherit</headercontainer>
     <fixedheader>inherit</fixedheader>
     <bodyloaded>inherit</bodyloaded>
     <brandlogo>inherit</brandlogo>
     <brandlogoasbanner>inherit</brandlogoasbanner>
     <surveylistlogo>inherit</surveylistlogo>
     <poweredlogo>inherit</poweredlogo>
     <poweredlink>inherit</poweredlink>
     <poweredtext>inherit</poweredtext>
     <availablevariations>inherit</availablevariations>
    </options>
   </config>
  </theme>
  <theme>
   <sid>476956</sid>
   <template_name>vanilla</template_name>
   <config>
    <options>inherit</options>
   </config>
  </theme>
 </themes>
 <themes_inherited>
  <theme>
   <sid>476956</sid>
   <template_name>skelvanilla</template_name>
   <config>
    <options>
     <general_inherit>1</general_inherit>
     <fixnumauto>disable</fixnumauto>
     <theme>css/variations/contrast-awesome.min.css</theme>
     <questionsize>h4</questionsize>
     <questioncolor>primary</questioncolor>
     <questionwrap>none</questionwrap>
     <helpcolor>text-info</helpcolor>
     <validitycolor>text-info</validitycolor>
     <titlelocation>header</titlelocation>
     <brandlogofile>./files/logo.png</brandlogofile>
     <surveylistlogofile>./files/survey_list_header.png</surveylistlogofile>
     <poweredlogofile>./files/poweredby.png</poweredlogofile>
     <hideprivacyinfo>off</hideprivacyinfo>
     <questionhtag>off</questionhtag>
     <removeback>on</removeback>
     <dynamicvalidity>off</dynamicvalidity>
     <showclearall>on</showclearall>
     <tableheader>on</tableheader>
     <savelink>on</savelink>
     <clearalllink>on</clearalllink>
     <indexlink>on</indexlink>
     <languagelink>on</languagelink>
     <previouslink>off</previouslink>
     <nextsubmitlink>off</nextsubmitlink>
     <container>on</container>
     <headercontainer>off</headercontainer>
     <fixedheader>off</fixedheader>
     <bodyloaded>on</bodyloaded>
     <brandlogo>off</brandlogo>
     <brandlogoasbanner>off</brandlogoasbanner>
     <surveylistlogo>on</surveylistlogo>
     <poweredlogo>on</poweredlogo>
     <poweredlink>https://sondages.pro</poweredlink>
     <poweredtext>Theme by Sondages Pro</poweredtext>
     <availablevariations>{
  &quot;contrast&quot;: {
    &quot;name&quot;: &quot;Contrast&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;bootstrap&quot;: {
    &quot;name&quot;: &quot;Bootstrap&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;cerulean&quot;: {
    &quot;name&quot;: &quot;Cerulean&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;cosmo&quot;: {
    &quot;name&quot;: &quot;Cosmo&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;cyborg&quot;: {
    &quot;name&quot;: &quot;Cyborg&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;darkly&quot;: {
    &quot;name&quot;: &quot;Darkly&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;flatly&quot;: {
    &quot;name&quot;: &quot;Flatly&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;journal&quot;: {
    &quot;name&quot;: &quot;Journal&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;lumen&quot;: {
    &quot;name&quot;: &quot;Lumen&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;paper&quot;: {
    &quot;name&quot;: &quot;Paper&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;readable&quot;: {
    &quot;name&quot;: &quot;Readable&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;sandstone&quot;: {
    &quot;name&quot;: &quot;Sandstone&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;simplex&quot;: {
    &quot;name&quot;: &quot;Simplex&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;slate&quot;: {
    &quot;name&quot;: &quot;Slate&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;spacelab&quot;: {
    &quot;name&quot;: &quot;Spacelab&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;superhero&quot;: {
    &quot;name&quot;: &quot;Superhero&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;united&quot;: {
    &quot;name&quot;: &quot;United&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;yeti&quot;: {
    &quot;name&quot;: &quot;Yeti&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;fruity-apple_blossom&quot;: {
    &quot;name&quot;: &quot;(Fruity) Apple Blossom&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;fruity-black_pearl&quot;: {
    &quot;name&quot;: &quot;(Fruity) Black Pearl&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;fruity-free_magenta&quot;: {
    &quot;name&quot;: &quot;(Fruity) Free magenta&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;fruity-purple_tentacle&quot;: {
    &quot;name&quot;: &quot;(Fruity) Purple Tentacle&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;fruity-sea_green&quot;: {
    &quot;name&quot;: &quot;(Fruity) Sea Green&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;fruity-skyline_blue&quot;: {
    &quot;name&quot;: &quot;(Fruity) Skyline Blue&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  },
  &quot;fruity-sunset_orange&quot;: {
    &quot;name&quot;: &quot;(Fruity) Sunset Orange&quot;,
    &quot;base&quot;: &quot;1&quot;,
    &quot;button&quot;: &quot;1&quot;,
    &quot;awesome&quot;: &quot;1&quot;,
    &quot;button_awesome&quot;: &quot;1&quot;
  }
}</availablevariations>
    </options>
   </config>
  </theme>
  <theme>
   <sid>476956</sid>
   <template_name>vanilla</template_name>
   <config>
    <options>
     <ajaxmode>off</ajaxmode>
     <brandlogo>on</brandlogo>
     <container>on</container>
     <hideprivacyinfo>off</hideprivacyinfo>
     <brandlogofile>./files/logo.png</brandlogofile>
     <font>noto</font>
    </options>
   </config>
  </theme>
 </themes_inherited>
</document>
limesurvey_survey_476956.lss (42,089 bytes)   
Bug heat4
Complete LimeSurvey version number (& build)5.2.9
I will donate to the project if issue is resolvedNo
Browsernot relevant
Database type & versionmariadb
Server OS (if known)fedora/linux
Webserver software & version (if known)nginx
PHP Version7.4

Users monitoring this issue

There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2022-01-10 16:55

developer   ~67944

The request is OK
Doing the request on SQl : return 2 values

Activating SQLdebug show : system.db.CDbCommand.query(SELECT t.qaid, t.qid, t.attribute, t.value, t.language FROM lime_question_attributes t LEFT JOIN lime_questions as question ON question.qid=t.qid WHERE question.sid = :sid and attribute = :attribute and value = :value. Bound with :sid='755657', :attribute='pdfReport', :value='1')

I test before xssFilter fix : seems OK.

I go before 5.2 …

DenisChenu

DenisChenu

2022-01-10 17:17

developer   ~67946

Last edited: 2022-01-11 17:15

Workaround : usage of findAllByArray
Related : https://github.com/LimeSurvey/LimeSurvey/blob/538e0706f17938b31631c4b76874020323da7afd/application/models/LSActiveRecord.php#L63 ?

But why this broke with find ?

gabrieljenik

gabrieljenik

2022-01-25 12:58

manager   ~68090

QuestionAttribute model has a default scope.
That default scope doesn't impact the query, but how the results are populated from the DB: populateRecords() uses the "attribute" attribute as the index of the array, and is therefore overwritten and a single record is returned.

If you disable it, everything will be OK.

/**
     * This defaultScope indexes the ActiveRecords given back by attribute name
     * Important: This does not work if you want to retrieve records for more than one question at a time.
     * In that case disable the defaultScope by using MyModel::model()->resetScope()->findAll();
     * @return array Scope that indexes the records by their attribute bane
     */
    public function defaultScope()
    {
        return array('index' => 'attribute');
    }
DenisChenu

DenisChenu

2022-01-25 14:24

developer   ~68091

Why adding this defaultScope ?
What usage ?
Even with one question : attribute is not the index with lang.

This must be removed from defaultScope , no ?

gabrieljenik

gabrieljenik

2022-01-26 13:21

manager   ~68114

Not sure. It was like that when I found it!
We could remove it, but I suggest to create a new story for it and have @galads prioritize it.
Removing it would require some research and quite some testing. That's the problem.

DenisChenu

DenisChenu

2022-01-26 15:14

developer   ~68116

I ask on commit from @c_schmitz

https://github.com/LimeSurvey/LimeSurvey/commit/7213088904adc71c027c097f13cbb76605801a5c#diff-ac521af6038093a1c4c5c35c0e901c23f2f4dc0572163912ad047d4f12a4574b

I don't understand why adding it.
And since this update disable Yii Core system :)

Issue History

Date Modified Username Field Change
2022-01-10 16:52 DenisChenu New Issue
2022-01-10 16:52 DenisChenu File Added: pdfReport.zip
2022-01-10 16:52 DenisChenu File Added: limesurvey_survey_476956.lss
2022-01-10 16:55 DenisChenu Note Added: 67944
2022-01-10 16:55 DenisChenu Bug heat 0 => 2
2022-01-10 17:17 DenisChenu Note Added: 67946
2022-01-10 17:45 ollehar Product Version => 5.2.x
2022-01-11 17:15 galads Assigned To => galads
2022-01-11 17:15 galads Status new => confirmed
2022-01-11 17:15 galads Zoho Project Synchronization => |Yes|
2022-01-25 12:58 gabrieljenik Note Added: 68090
2022-01-25 12:58 gabrieljenik Bug heat 2 => 4
2022-01-25 14:24 DenisChenu Note Added: 68091
2022-01-26 13:21 gabrieljenik Note Added: 68114
2022-01-26 15:14 DenisChenu Note Added: 68116
2022-02-23 10:35 galads Zoho Project Synchronization Yes =>