15980: No results shown for selected date questions at statistics

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

15980	Bug reports	Statistics	public	2020-03-12 21:26	2020-09-07 11:49

Reporter	Mazi	Assigned To	gabrieljenik
Priority	none	Severity	partial_block
Status	closed	Resolution	fixed
Product Version	3.22.8

Summary	15980: No results shown for selected date questions at statistics
Description	Equation or text display questions are not available to be selected at the statistics feature. But the date questions can be selected. Thing is that even when you are selecting a date question, no results are shown for those questions, they are simply ignored. You can call that a missing feature, I'd consider it a bug since we can select the question but nothing gets shown for it. We could simply show date question results similar to text input questions (list of text strings) because you can't really put date details into charts. Brave people would also try adding a min/max date filter similar to the one we have for the submit date.
Steps To Reproduce	Pick an activated survey with a date question. Select only the data question at the statistics module. There are no results shown for date questions
Additional Information	This is most probably also an issue at LS 4
Tags	No tags attached.
Attached Files

Bug heat	10
Complete LimeSurvey version number (& build)	Version 3.17.3+190429
I will donate to the project if issue is resolved	No
Browser	Chrome
Database type & version	MySQL 5
Server OS (if known)	?
Webserver software & version (if known)
PHP Version	7.x

User List	There are no users monitoring this issue.

ollehar 2020-03-13 11:07 administrator ~56441	Please update to the latest version and try again. Thank you.

Mazi 2020-03-13 13:53 updater ~56442 Last edited: 2020-04-01 17:30	@ollehar, just tested with latest Version 3.22.8+200309. There now is a filter for min/max date but no results of the date question are shown at all, even though the question was selected. image.png (84,755 bytes) image.png (84,755 bytes) question_selection.png (29,233 bytes) question_selection.png (29,233 bytes)

ollehar 2020-03-13 14:15 administrator ~56443 Last edited: 2020-04-01 17:30	I will assign this to Dorin and he'll have a look on Monday. He's on vacation this week. Thanks for reporting, Marcell!

gabrieljenik 2020-08-17 17:56 manager ~59491	https://github.com/LimeSurvey/LimeSurvey/pull/1553 Date/Time responses are treated as "Answer" when the value is not null, and "No answer" when it's null. Equation questions are handled as text. It seems they always have a value, so "Not displayed" may always be 0. Condition had to be updated as to work with dates. It may have an impact on some DB engine (not sure). Found issue 16598 while reviewing. Both 16598 and 15980 could be happening on LS4 as well

~~user225042~~ 2020-08-20 12:38 ~59552	Tested the issue before pulling the PR, Issue exist. Tested the issue after pulling the PR, below are my findings: Screenshot 1: Before PR, Date question is not displayed in results Screenshot 2:After PR, Date question is displayed in results Please refer the attachment for more details, Working as Expected 15980_Dateques_Statis_Notshowed.png (181,567 bytes) 15980_Dateques_Statis_showed.png (99,788 bytes) 15980_Dateques_Statis_showed.png (99,788 bytes)

gabrieljenik 2020-08-25 17:36 manager ~59612	Fix committed to 3.x-LTS branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=30424

lime_release_bot 2020-09-07 11:49 administrator ~59722	Fixed in Release 3.23.2+200908

LimeSurvey: 3.x-LTS 90810b8f 2020-08-14 22:32 gabrieljenik Details Diff	Fixed issue 15980: No results shown for selected date questions at statistics - Date/Time responses are treated as "Answer" when the value is not null, and "No answer" when it's null. - Equation questions are handled as text. It seems they always have a value, so "Not displayed" may always be 0. - Condition had to be updated as to work with dates. It may have an impact on some DB engine (not sure).	Affected Issues 15980
	mod - application/helpers/admin/statistics_helper.php	Diff File
	mod - application/views/admin/export/statistics_subviews/_question.php	Diff File
LimeSurvey: 3.x-LTS 460a012a 2020-08-25 19:36 ollehar1 Committer: GitHub Details Diff	Fixed issue 15980: No results shown for selected date questions at statistics	Affected Issues 15980
	mod - application/helpers/admin/statistics_helper.php	Diff File
	mod - application/views/admin/export/statistics_subviews/_question.php	Diff File

Date Modified	Username	Field	Change
2020-03-12 21:26	Mazi	New Issue
2020-03-13 11:07	ollehar	Note Added: 56441
2020-03-13 11:07	ollehar	Status	new => feedback
2020-03-13 13:53	Mazi	File Added: image.png
2020-03-13 13:53	Mazi	File Added: question_selection.png
2020-03-13 13:53	Mazi	Note Added: 56442
2020-03-13 13:53	Mazi	Status	feedback => new
2020-03-13 14:13	ollehar	Product Version	3.19.1 => 3.22.8
2020-03-13 14:14	ollehar	Assigned To	=> cdorin
2020-03-13 14:14	ollehar	Status	new => assigned
2020-03-13 14:15	ollehar	Note Added: 56443
2020-03-13 14:17	ollehar	Note Edited: 56443
2020-04-01 17:30	cdorin	Zoho Sprints	=> \|Yes\|
2020-04-01 17:30	~~swendrich~~	Zoho Sprints ID	=> 14469000000017181
2020-08-17 17:26	gabrieljenik	Issue cloned: 16598
2020-08-17 17:26	gabrieljenik	Relationship added	related to 16598
2020-08-17 17:56	gabrieljenik	Note Added: 59491
2020-08-20 12:38	~~user225042~~	Note Added: 59552
2020-08-20 12:38	~~user225042~~	File Added: 15980_Dateques_Statis_Notshowed.png
2020-08-20 12:38	~~user225042~~	File Added: 15980_Dateques_Statis_showed.png
2020-08-25 17:36	ollehar1	Changeset attached	=> LimeSurvey 3.x-LTS 460a012a
2020-08-25 17:36	gabrieljenik	Changeset attached	=> LimeSurvey 3.x-LTS 90810b8f
2020-08-25 17:36	gabrieljenik	Note Added: 59612
2020-08-25 17:36	gabrieljenik	Assigned To	cdorin => gabrieljenik
2020-08-25 17:36	gabrieljenik	Resolution	open => fixed
2020-09-07 11:49	lime_release_bot	Zoho Sprints	Yes => \|Yes\|
2020-09-07 11:49	lime_release_bot	Note Added: 59722
2020-09-07 11:49	lime_release_bot	Status	assigned => closed

View Issue Details

Relationships

Users monitoring this issue

Activities

Related Changesets

Issue History