View Issue Details

This bug affects 1 person(s).
 2
IDProjectCategoryView StatusLast Update
17829Bug reportsOtherpublic2022-01-11 17:15
ReporterDenisChenu Assigned Togalads  
PrioritynoneSeverityminor 
Status confirmedResolutionopen 
Product Version5.2.x 
Summary17829: findAll return only one record
Descriptionusing findAll with QuestionAttribute model return only one record.
Steps To ReproduceSteps 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.
Bug heat2
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

User List There are no users monitoring this issue.

Activities

DenisChenu

DenisChenu

2022-01-10 16:52

developer  

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)   
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 ?

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