View Issue Details

IDProjectCategoryView StatusLast Update
09204DevelopmentImport/Exportpublic2026-11-20 18:19
ReporterDenisChenu Assigned To 
PrioritynormalSeverityminor 
Status acknowledgedResolutionopen 
Summary09204: No difference in DB between un-answered question an un-relevant question for DATE and NUMERIC
Description

In DB , or VV export : date question type and numeric question type are set to NULL and show {question_not_shown} in VV

Steps To Reproduce

Create (or import) a survey with a date question type and a numeric question type.
Activate the survey , and launch survey.
Don't answer to any question,
Export VV file or look at DB : DB colum are set to NULL

Additional Information

DECIMAL and DATE disallow '' for value.

For date maybe we can use 00-00-00 for not-answered question and NULL for un relevant question. Not sure it's good.

I think it's better to have a difference between not answered and not view . Actually user see it in statistics and VV export, but some plugin can update this.

Set to 2.00 because it's an old issue.

TagsNo tags attached.
Attached Files

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2026-11-20 14:59

administrator   ~87819

Possible fixes:

  • Placeholder values (Denis's idea, e.g. 0000-00-00 for dates). This doesn't work well. MySQL in strict mode, PostgreSQL and MSSQL reject zero dates. Numbers have no safe placeholder value. Every statistics and export path would also have to filter the placeholder out.
  • Store '' only for text columns. This would fix the encrypted case cheaply. But the same question would then behave differently depending on whether encryption is on, which is confusing.
  • Record "shown/answered" separately, for example in a per-question status column, or by working it out from relevance when exporting. This is the only clean fix, but it means a schema change and a large amount of work.

Issue History

Date Modified Username Field Change
2014-09-02 18:07 DenisChenu New Issue
2014-09-02 18:07 DenisChenu File Added: limesurvey_survey_nullvalue.lss
2026-11-19 22:50 c_schmitz Status new => acknowledged
2026-11-20 14:59 c_schmitz Note Added: 87819
2026-11-20 14:59 c_schmitz Bug heat 0 => 2
2026-11-20 18:19 c_schmitz Project Bug reports => Development
2026-11-20 18:19 c_schmitz Product Version 2.00 =>