View Issue Details

This issue affects 1 person(s).
 0
IDProjectCategoryView StatusLast Update
09204Bug reportsImport/Exportpublic2026-11-19 22:50
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
Bug heat0
Complete LimeSurvey version number (& build)
I will donate to the project if issue is resolved
Browser
Database type & version
Server OS (if known)
Webserver software & version (if known)
PHP Version
Git branch / Pull Request URL

Users monitoring this issue

There are no users monitoring this issue.

Activities

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