NULL V.S. BLANK

More
1 year 7 months ago #134545 by david2013
david2013 created the topic: NULL V.S. BLANK
Not-relevant (i.e. a question is skipped or options are filtered) always stores NULL in the database. Options are shown but not selected store an empty (blank) string in the database. This is great except for multiple choice question with exclusive option.

When we have multiple choice question with exclusive option, if user choose exclusive option (i.e. "None of the above"), then all other options store as NULL in the database. I believe it should be BLANK instead of NULL because those options are shown up. Is it a bug or expected behaviour?

Currently, we cannot tell the difference between "option is been filtered" or "it's been disabled by exclusive option" when looking at the data.

Please Log in to join the conversation.

More
1 year 7 months ago #134549 by DenisChenu
DenisChenu replied the topic: NULL V.S. BLANK
I think it's expected behaviour.

But if user see the "None of the above" : he see the question.

Maybe we can save "" if relevance is set to "diabled" and null if it set to hidden.

feature request

Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand (or search sondages pro).
An error happen ? Before make a new topic : remind the Debug mode .
The following user(s) said Thank You: david2013

Please Log in to join the conversation.

More
1 year 7 months ago #134606 by david2013
david2013 replied the topic: NULL V.S. BLANK

Please Log in to join the conversation.

More
1 year 7 months ago #134670 by first
first replied the topic: NULL V.S. BLANK
I guess you want data format as we get from tools like confirmit :)

www.limesurvey.org/community-services/fo...f-question-not-shown

Survey Designer and Programmer

Please Log in to join the conversation.

More
5 months 3 days ago #156626 by relaxpn
relaxpn replied the topic: NULL V.S. BLANK
Hi!

Sorry for bumping this old thread but this is still an issue.
Is there any workaround for this (insert blank for answers that were shown and NULL for hidden ones)?

Please Log in to join the conversation.

More
4 months 3 days ago #157417 by relaxpn
relaxpn replied the topic: NULL V.S. BLANK
Me again :(

Can anyone point me in the right direction, which function/file handles the data collection, I'll try to debug it and maybe provide a workaround.

I have attached an example suvey, where you can easily reproduce the given problem.
Attachments:

Please Log in to join the conversation.

Start now!

Just create your account and start using Limesurvey today.

Register now
Join our Newsletter!