19386: Survey archive didn't respect NULL value - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

19386	Bug reports	Import/Export	public	2024-01-31 16:08	2024-01-31 16:09

Reporter	DenisChenu	Assigned To
Priority	none	Severity	minor
Status	new	Resolution	open
Product Version	5.6.x

Summary	19386: Survey archive didn't respect NULL value
Description	When import survey archive : empty value (for multiple choice at least) are set to NULL
Steps To Reproduce	Steps to reproduce Import included LSS Activate Test : didn't check any checkbox in 1st question Export as CSV : result shown N/A for Filtered and empty string for Select Export LSA Import LSA Export as CSV : heck the result Expected result shown N/A for Filtered and empty string for Select Actual result shown N/A for Filtered and Select
Tags	No tags attached.
Attached Files	limesurvey_survey_MultipleChoiceFilter.lss (40,877 bytes) <?xml version="1.0" encoding="UTF-8"?> <document> <LimeSurveyDocType>Survey</LimeSurveyDocType> <DBVersion>499</DBVersion> <languages> <language>en</language> </languages> <groups> <fields> <fieldname>gid</fieldname> <fieldname>sid</fieldname> <fieldname>group_order</fieldname> <fieldname>randomization_group</fieldname> <fieldname>grelevance</fieldname> </fields> <rows> <row> <gid><![CDATA[537]]></gid> <sid><![CDATA[932686]]></sid> <group_order><![CDATA[1]]></group_order> <randomization_group/> <grelevance><![CDATA[1]]></grelevance> </row> </rows> </groups> <group_l10ns> <fields> <fieldname>id</fieldname> <fieldname>gid</fieldname> <fieldname>group_name</fieldname> <fieldname>description</fieldname> <fieldname>language</fieldname> <fieldname>sid</fieldname> <fieldname>group_order</fieldname> <fieldname>randomization_group</fieldname> <fieldname>grelevance</fieldname> </fields> <rows> <row> <id><![CDATA[1246]]></id> <gid><![CDATA[537]]></gid> <group_name><![CDATA[My first question group]]></group_name> <language><![CDATA[en]]></language> <sid><![CDATA[932686]]></sid> <group_order><![CDATA[1]]></group_order> <randomization_group/> <grelevance><![CDATA[1]]></grelevance> </row> </rows> </group_l10ns> <questions> <fields> <fieldname>qid</fieldname> <fieldname>parent_qid</fieldname> <fieldname>sid</fieldname> <fieldname>gid</fieldname> <fieldname>type</fieldname> <fieldname>title</fieldname> <fieldname>preg</fieldname> <fieldname>other</fieldname> <fieldname>mandatory</fieldname> <fieldname>encrypted</fieldname> <fieldname>question_order</fieldname> <fieldname>scale_id</fieldname> <fieldname>same_default</fieldname> <fieldname>relevance</fieldname> <fieldname>question_theme_name</fieldname> <fieldname>modulename</fieldname> <fieldname>same_script</fieldname> </fields> <rows> <row> <qid><![CDATA[5599]]></qid> <parent_qid><![CDATA[0]]></parent_qid> <sid><![CDATA[932686]]></sid> <gid><![CDATA[537]]></gid> <type><![CDATA[M]]></type> <title><![CDATA[Select]]></title> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <encrypted><![CDATA[N]]></encrypted> <question_order><![CDATA[1]]></question_order> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <question_theme_name><![CDATA[multiplechoice]]></question_theme_name> <same_script><![CDATA[0]]></same_script> </row> <row> <qid><![CDATA[5603]]></qid> <parent_qid><![CDATA[0]]></parent_qid> <sid><![CDATA[932686]]></sid> <gid><![CDATA[537]]></gid> <type><![CDATA[M]]></type> <title><![CDATA[Filtered]]></title> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <encrypted><![CDATA[N]]></encrypted> <question_order><![CDATA[2]]></question_order> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <question_theme_name><![CDATA[multiplechoice]]></question_theme_name> <same_script><![CDATA[0]]></same_script> </row> <row> <qid><![CDATA[5607]]></qid> <parent_qid><![CDATA[0]]></parent_qid> <sid><![CDATA[932686]]></sid> <gid><![CDATA[537]]></gid> <type><![CDATA[C]]></type> <title><![CDATA[FilteredArray]]></title> <other><![CDATA[N]]></other> <mandatory><![CDATA[N]]></mandatory> <encrypted><![CDATA[N]]></encrypted> <question_order><![CDATA[3]]></question_order> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <question_theme_name><![CDATA[arrays/yesnouncertain]]></question_theme_name> <same_script><![CDATA[0]]></same_script> </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>preg</fieldname> <fieldname>other</fieldname> <fieldname>mandatory</fieldname> <fieldname>encrypted</fieldname> <fieldname>question_order</fieldname> <fieldname>scale_id</fieldname> <fieldname>same_default</fieldname> <fieldname>relevance</fieldname> <fieldname>question_theme_name</fieldname> <fieldname>modulename</fieldname> <fieldname>same_script</fieldname> </fields> <rows> <row> <qid><![CDATA[5600]]></qid> <parent_qid><![CDATA[5599]]></parent_qid> <sid><![CDATA[932686]]></sid> <gid><![CDATA[537]]></gid> <type><![CDATA[T]]></type> <title><![CDATA[SQ001]]></title> <other><![CDATA[N]]></other> <encrypted><![CDATA[N]]></encrypted> <question_order><![CDATA[0]]></question_order> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <question_theme_name><![CDATA[longfreetext]]></question_theme_name> <same_script><![CDATA[0]]></same_script> </row> <row> <qid><![CDATA[5601]]></qid> <parent_qid><![CDATA[5599]]></parent_qid> <sid><![CDATA[932686]]></sid> <gid><![CDATA[537]]></gid> <type><![CDATA[T]]></type> <title><![CDATA[SQ002]]></title> <other><![CDATA[N]]></other> <encrypted><![CDATA[N]]></encrypted> <question_order><![CDATA[1]]></question_order> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <question_theme_name><![CDATA[longfreetext]]></question_theme_name> <same_script><![CDATA[0]]></same_script> </row> <row> <qid><![CDATA[5602]]></qid> <parent_qid><![CDATA[5599]]></parent_qid> <sid><![CDATA[932686]]></sid> <gid><![CDATA[537]]></gid> <type><![CDATA[T]]></type> <title><![CDATA[SQ003]]></title> <other><![CDATA[N]]></other> <encrypted><![CDATA[N]]></encrypted> <question_order><![CDATA[2]]></question_order> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <question_theme_name><![CDATA[longfreetext]]></question_theme_name> <same_script><![CDATA[0]]></same_script> </row> <row> <qid><![CDATA[5604]]></qid> <parent_qid><![CDATA[5603]]></parent_qid> <sid><![CDATA[932686]]></sid> <gid><![CDATA[537]]></gid> <type><![CDATA[T]]></type> <title><![CDATA[SQ003]]></title> <other><![CDATA[N]]></other> <encrypted><![CDATA[N]]></encrypted> <question_order><![CDATA[2]]></question_order> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <question_theme_name><![CDATA[longfreetext]]></question_theme_name> <same_script><![CDATA[0]]></same_script> </row> <row> <qid><![CDATA[5605]]></qid> <parent_qid><![CDATA[5603]]></parent_qid> <sid><![CDATA[932686]]></sid> <gid><![CDATA[537]]></gid> <type><![CDATA[T]]></type> <title><![CDATA[SQ002]]></title> <other><![CDATA[N]]></other> <encrypted><![CDATA[N]]></encrypted> <question_order><![CDATA[1]]></question_order> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <question_theme_name><![CDATA[longfreetext]]></question_theme_name> <same_script><![CDATA[0]]></same_script> </row> <row> <qid><![CDATA[5606]]></qid> <parent_qid><![CDATA[5603]]></parent_qid> <sid><![CDATA[932686]]></sid> <gid><![CDATA[537]]></gid> <type><![CDATA[T]]></type> <title><![CDATA[SQ001]]></title> <other><![CDATA[N]]></other> <encrypted><![CDATA[N]]></encrypted> <question_order><![CDATA[0]]></question_order> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <question_theme_name><![CDATA[longfreetext]]></question_theme_name> <same_script><![CDATA[0]]></same_script> </row> <row> <qid><![CDATA[5608]]></qid> <parent_qid><![CDATA[5607]]></parent_qid> <sid><![CDATA[932686]]></sid> <gid><![CDATA[537]]></gid> <type><![CDATA[T]]></type> <title><![CDATA[SQ002]]></title> <other><![CDATA[N]]></other> <encrypted><![CDATA[N]]></encrypted> <question_order><![CDATA[1]]></question_order> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <question_theme_name><![CDATA[longfreetext]]></question_theme_name> <same_script><![CDATA[0]]></same_script> </row> <row> <qid><![CDATA[5609]]></qid> <parent_qid><![CDATA[5607]]></parent_qid> <sid><![CDATA[932686]]></sid> <gid><![CDATA[537]]></gid> <type><![CDATA[T]]></type> <title><![CDATA[SQ001]]></title> <other><![CDATA[N]]></other> <encrypted><![CDATA[N]]></encrypted> <question_order><![CDATA[0]]></question_order> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <question_theme_name><![CDATA[longfreetext]]></question_theme_name> <same_script><![CDATA[0]]></same_script> </row> <row> <qid><![CDATA[5610]]></qid> <parent_qid><![CDATA[5607]]></parent_qid> <sid><![CDATA[932686]]></sid> <gid><![CDATA[537]]></gid> <type><![CDATA[T]]></type> <title><![CDATA[SQ003]]></title> <other><![CDATA[N]]></other> <encrypted><![CDATA[N]]></encrypted> <question_order><![CDATA[2]]></question_order> <scale_id><![CDATA[0]]></scale_id> <same_default><![CDATA[0]]></same_default> <relevance><![CDATA[1]]></relevance> <question_theme_name><![CDATA[longfreetext]]></question_theme_name> <same_script><![CDATA[0]]></same_script> </row> </rows> </subquestions> <question_l10ns> <fields> <fieldname>id</fieldname> <fieldname>qid</fieldname> <fieldname>question</fieldname> <fieldname>help</fieldname> <fieldname>script</fieldname> <fieldname>language</fieldname> </fields> <rows> <row> <id><![CDATA[12469]]></id> <qid><![CDATA[5599]]></qid> <question><![CDATA[A first example question. Please answer this question:]]></question> <help><![CDATA[This is a question help text.]]></help> <script/> <language><![CDATA[en]]></language> </row> <row> <id><![CDATA[12470]]></id> <qid><![CDATA[5600]]></qid> <question><![CDATA[Choice 1]]></question> <language><![CDATA[en]]></language> </row> <row> <id><![CDATA[12471]]></id> <qid><![CDATA[5601]]></qid> <question><![CDATA[Choice 2]]></question> <language><![CDATA[en]]></language> </row> <row> <id><![CDATA[12472]]></id> <qid><![CDATA[5602]]></qid> <question><![CDATA[Choice 3]]></question> <language><![CDATA[en]]></language> </row> <row> <id><![CDATA[12473]]></id> <qid><![CDATA[5603]]></qid> <question><![CDATA[Filtered]]></question> <help><![CDATA[This is a question help text.]]></help> <script/> <language><![CDATA[en]]></language> </row> <row> <id><![CDATA[12474]]></id> <qid><![CDATA[5604]]></qid> <question><![CDATA[Choice 3]]></question> <language><![CDATA[en]]></language> </row> <row> <id><![CDATA[12475]]></id> <qid><![CDATA[5605]]></qid> <question><![CDATA[Choice 2]]></question> <language><![CDATA[en]]></language> </row> <row> <id><![CDATA[12476]]></id> <qid><![CDATA[5606]]></qid> <question><![CDATA[Choice 1]]></question> <language><![CDATA[en]]></language> </row> <row> <id><![CDATA[12477]]></id> <qid><![CDATA[5607]]></qid> <question><![CDATA[Filtered array]]></question> <help><![CDATA[This is a question help text.]]></help> <script/> <language><![CDATA[en]]></language> </row> <row> <id><![CDATA[12478]]></id> <qid><![CDATA[5608]]></qid> <question><![CDATA[Choice 2]]></question> <language><![CDATA[en]]></language> </row> <row> <id><![CDATA[12479]]></id> <qid><![CDATA[5609]]></qid> <question><![CDATA[Choice 1]]></question> <language><![CDATA[en]]></language> </row> <row> <id><![CDATA[12480]]></id> <qid><![CDATA[5610]]></qid> <question><![CDATA[Choice 3]]></question> <language><![CDATA[en]]></language> </row> </rows> </question_l10ns> <question_attributes> <fields> <fieldname>qid</fieldname> <fieldname>attribute</fieldname> <fieldname>value</fieldname> <fieldname>language</fieldname> </fields> <rows> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[array_filter]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[array_filter_exclude]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[array_filter_style]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[assessment_value]]></attribute> <value><![CDATA[1]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[commentsOnSurvey_append]]></attribute> <value><![CDATA[text]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[commentsOnSurvey_comments]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[cssclass]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[display_columns]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[em_validation_q]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[em_validation_q_tip]]></attribute> <value/> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[exclude_all_others]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[exclude_all_others_auto]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[hidden]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[hide_tip]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[javascript]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[max_answers]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[min_answers]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[other_numbers_only]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[other_position]]></attribute> <value><![CDATA[end]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[other_position_code]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[other_replace_text]]></attribute> <value/> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[page_break]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[printable_help]]></attribute> <value/> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[public_statistics]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[random_group]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[random_order]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[readonly]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[save_as_default]]></attribute> <value><![CDATA[N]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[scale_export]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[scriptActivate]]></attribute> <value><![CDATA[1]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[statistics_graphtype]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[statistics_showgraph]]></attribute> <value><![CDATA[1]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[UncheckMultipleMax]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5599]]></qid> <attribute><![CDATA[UncheckMultipleMaxHideTip]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[array_filter]]></attribute> <value><![CDATA[Select]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[array_filter_exclude]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[array_filter_style]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[assessment_value]]></attribute> <value><![CDATA[1]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[commentsOnSurvey_append]]></attribute> <value><![CDATA[text]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[commentsOnSurvey_comments]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[cssclass]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[display_columns]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[em_validation_q]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[em_validation_q_tip]]></attribute> <value/> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[exclude_all_others]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[exclude_all_others_auto]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[hidden]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[hide_tip]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[javascript]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[max_answers]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[min_answers]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[other_numbers_only]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[other_position]]></attribute> <value><![CDATA[end]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[other_position_code]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[other_replace_text]]></attribute> <value/> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[page_break]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[printable_help]]></attribute> <value/> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[public_statistics]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[random_group]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[random_order]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[readonly]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[save_as_default]]></attribute> <value><![CDATA[N]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[scale_export]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[scriptActivate]]></attribute> <value><![CDATA[1]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[statistics_graphtype]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[statistics_showgraph]]></attribute> <value><![CDATA[1]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[UncheckMultipleMax]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5603]]></qid> <attribute><![CDATA[UncheckMultipleMaxHideTip]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[answer_width]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[array_filter]]></attribute> <value><![CDATA[Select]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[array_filter_exclude]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[array_filter_style]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[assessment_value]]></attribute> <value><![CDATA[1]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[commentsOnSurvey_append]]></attribute> <value><![CDATA[text]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[commentsOnSurvey_comments]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[cssclass]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[display_columns]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[em_validation_q]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[em_validation_q_tip]]></attribute> <value/> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[exclude_all_others]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[exclude_all_others_auto]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[hidden]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[hide_tip]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[javascript]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[max_answers]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[min_answers]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[other_numbers_only]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[other_position]]></attribute> <value><![CDATA[end]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[other_position_code]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[other_replace_text]]></attribute> <value/> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[page_break]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[printable_help]]></attribute> <value/> <language><![CDATA[en]]></language> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[public_statistics]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[random_group]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[random_order]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[readonly]]></attribute> <value/> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[save_as_default]]></attribute> <value><![CDATA[N]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[scale_export]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[scriptActivate]]></attribute> <value><![CDATA[1]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[statistics_graphtype]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[statistics_showgraph]]></attribute> <value><![CDATA[1]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[UncheckMultipleMax]]></attribute> <value><![CDATA[0]]></value> <language/> </row> <row> <qid><![CDATA[5607]]></qid> <attribute><![CDATA[UncheckMultipleMaxHideTip]]></attribute> <value><![CDATA[0]]></value> <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>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>ipanonymize</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> <fieldname>tokenencryptionoptions</fieldname> </fields> <rows> <row> <sid><![CDATA[932686]]></sid> <gsid><![CDATA[1]]></gsid> <admin><![CDATA[inherit]]></admin> <adminemail><![CDATA[inherit]]></adminemail> <anonymized><![CDATA[N]]></anonymized> <format><![CDATA[I]]></format> <savetimings><![CDATA[N]]></savetimings> <template><![CDATA[inherit]]></template> <language><![CDATA[en]]></language> <additional_languages/> <datestamp><![CDATA[Y]]></datestamp> <usecookie><![CDATA[I]]></usecookie> <allowregister><![CDATA[I]]></allowregister> <allowsave><![CDATA[I]]></allowsave> <autonumber_start><![CDATA[0]]></autonumber_start> <autoredirect><![CDATA[I]]></autoredirect> <allowprev><![CDATA[I]]></allowprev> <printanswers><![CDATA[I]]></printanswers> <ipaddr><![CDATA[Y]]></ipaddr> <ipanonymize><![CDATA[Y]]></ipanonymize> <refurl><![CDATA[N]]></refurl> <showsurveypolicynotice><![CDATA[0]]></showsurveypolicynotice> <publicstatistics><![CDATA[I]]></publicstatistics> <publicgraphs><![CDATA[I]]></publicgraphs> <listpublic><![CDATA[I]]></listpublic> <htmlemail><![CDATA[I]]></htmlemail> <sendconfirmation><![CDATA[I]]></sendconfirmation> <tokenanswerspersistence><![CDATA[I]]></tokenanswerspersistence> <assessments><![CDATA[I]]></assessments> <usecaptcha><![CDATA[E]]></usecaptcha> <usetokens><![CDATA[N]]></usetokens> <bounce_email><![CDATA[inherit]]></bounce_email> <emailresponseto><![CDATA[inherit]]></emailresponseto> <emailnotificationto><![CDATA[inherit]]></emailnotificationto> <tokenlength><![CDATA[-1]]></tokenlength> <showxquestions><![CDATA[I]]></showxquestions> <showgroupinfo><![CDATA[I]]></showgroupinfo> <shownoanswer><![CDATA[I]]></shownoanswer> <showqnumcode><![CDATA[I]]></showqnumcode> <bounceprocessing><![CDATA[N]]></bounceprocessing> <showwelcome><![CDATA[I]]></showwelcome> <showprogress><![CDATA[I]]></showprogress> <questionindex><![CDATA[-1]]></questionindex> <navigationdelay><![CDATA[-1]]></navigationdelay> <nokeyboard><![CDATA[I]]></nokeyboard> <alloweditaftercompletion><![CDATA[I]]></alloweditaftercompletion> <tokenencryptionoptions><![CDATA[{ "enabled":"Y","columns":{ "firstname":"N","lastname":"N","email":"N" } }]]></tokenencryptionoptions> </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>surveyls_alias</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[932686]]></surveyls_survey_id> <surveyls_language><![CDATA[en]]></surveyls_language> <surveyls_title><![CDATA[Test NULL value]]></surveyls_title> <surveyls_description/> <surveyls_welcometext/> <surveyls_endtext/> <surveyls_policy_notice/> <surveyls_policy_notice_label/> <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 {FIRSTNAME},<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 /> If you have any further questions about this email, please contact {ADMINNAME} on {ADMINEMAIL}.<br /> <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 /> 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}]]></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 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> </row> </rows> </surveys_languagesettings> <themes> <theme> <sid>932686</sid> <template_name>fruity</template_name> <config> <options>inherit</options> </config> </theme> </themes> <themes_inherited> <theme> <sid>932686</sid> <template_name>fruity</template_name> <config> <options> <ajaxmode>off</ajaxmode> <brandlogo>on</brandlogo> <brandlogofile>image::theme::files/logo.png</brandlogofile> <container>on</container> <backgroundimage>off</backgroundimage> <animatebody>off</animatebody> <bodyanimation>fadeInRight</bodyanimation> <bodyanimationduration>500</bodyanimationduration> <animatequestion>off</animatequestion> <questionanimation>flipInX</questionanimation> <questionanimationduration>500</questionanimationduration> <animatealert>off</animatealert> <alertanimation>shake</alertanimation> <alertanimationduration>500</alertanimationduration> <font>noto</font> <bodybackgroundcolor>#ffffff</bodybackgroundcolor> <fontcolor>#444444</fontcolor> <questionbackgroundcolor>#ffffff</questionbackgroundcolor> <questionborder>on</questionborder> <questioncontainershadow>on</questioncontainershadow> <checkicon>f00c</checkicon> <animatecheckbox>on</animatecheckbox> <checkboxanimation>rubberBand</checkboxanimation> <checkboxanimationduration>500</checkboxanimationduration> <animateradio>on</animateradio> <radioanimation>zoomIn</radioanimation> <radioanimationduration>500</radioanimationduration> <zebrastriping>off</zebrastriping> <stickymatrixheaders>off</stickymatrixheaders> <greyoutselected>off</greyoutselected> <hideprivacyinfo>off</hideprivacyinfo> <crosshover>off</crosshover> <showpopups>1</showpopups> <showclearall>off</showclearall> <questionhelptextposition>top</questionhelptextposition> <notables>1</notables> </options> </config> </theme> </themes_inherited> </document> limesurvey_survey_MultipleChoiceFilter.lss (40,877 bytes)

Bug heat	0
Complete LimeSurvey version number (& build)	5.6.52 and 6.4.4
I will donate to the project if issue is resolved	No
Browser	not relevant
Database type & version	mariadb
Server OS (if known)	debian
Webserver software & version (if known)	nginx
PHP Version	php8.1 and php7.4

User List	There are no users monitoring this issue.

Date Modified	Username	Field	Change
2024-01-31 16:08	DenisChenu	New Issue
2024-01-31 16:08	DenisChenu	File Added: limesurvey_survey_MultipleChoiceFilter.lss
2024-01-31 16:09	DenisChenu	Relationship added	related to 19383

View Issue Details

Steps to reproduce

Expected result

Actual result

Relationships

Users monitoring this issue

Activities

Issue History