Dependency Graph

Dependency Graph
related to related to child of child of duplicate of duplicate of

View Issue Details

This bug affects 1 person(s).
 16
IDProjectCategoryView StatusLast Update
04189Bug reportsStatisticspublic2011-05-14 23:44
Reporteruser6961Assigned Tomachaven  
PrioritynormalSeveritypartial_block 
Status closedResolutionfixed 
Product Version1.87+ 
Target Version1.90RC1Fixed in Version1.90RC1 
Summary04189: Response Statistics - Date and number fields filters not working
Description

When I go to "Browse Responses for this survey" and select "Get statistics for these responses" I am not able to filter on fields that are of "Numerical input", "Array (Multi Flexible) (Numbers)" or "date" type.

When I configure a filter on such answer field it returns ALL responses as result.

TagsNo tags attached.
Attached Files
limesurvey_survey_49528.csv (4,956 bytes)   
# LimeSurvey Survey Dump
# DBVersion 142
# This is a dumped survey from the LimeSurvey Script
# http://www.limesurvey.org/
# Do not change this header!

#
# SURVEYS TABLE
#
"sid","owner_id","admin","active","expires","startdate","adminemail","private","faxto","format","template","language","additional_languages","datestamp","usecookie","notification","allowregister","allowsave","autonumber_start","autoredirect","allowprev","printanswers","ipaddr","refurl","datecreated","publicstatistics","publicgraphs","listpublic","htmlemail","tokenanswerspersistence","assessments","usecaptcha","usetokens","bounce_email","attributedescriptions","emailresponseto","tokenlength"
"49528","1","Your Name","Y","","","your@email.org","Y","","G","default","en","","N","N","0","N","Y","2","N","Y","N","N","N","2010-03-12","N","N","N","Y","N","N","D","N","your@email.org","","","15"

#
# GROUPS TABLE
#
"gid","sid","group_name","group_order","description","language"
"1","49528","a","0","","en"

#
# QUESTIONS TABLE
#
"qid","sid","gid","type","title","question","preg","help","other","mandatory","lid","lid1","question_order","language"
"1","49528","1","D","a","Date","","","N","N","0","2","0","en"
"41","49528","1","N","b","Numerical","","","N","N","0","0","1","en"
"42","49528","1",":","c","mult flex num","","","N","N","1","0","2","en"

#
# ANSWERS TABLE
#
"qid","code","answer","default_value","assessment_value","sortorder","language"
"42","aa","aa","N","0","1","en"
"42","bb","bb","N","0","2","en"

#
# CONDITIONS TABLE
#

#
# LABELSETS TABLE
#
"lid","label_name","languages"
"1","a","en"

#
# LABELS TABLE
#
"lid","code","title","sortorder","language","assessment_value"
"1","a","a","1","en","0"
"1","b","b","2","en","0"

#
# QUESTION_ATTRIBUTES TABLE
#
"qaid","qid","attribute","value"
"696","41","public_statistics","0"
"695","41","prefix",""
"694","41","page_break","0"
"693","41","maximum_chars",""
"692","41","hidden","0"
"691","41","hide_tip","0"
"8","1","hidden","0"
"9","1","page_break","0"
"690","1","dropdown_dates_year_max",""
"689","1","dropdown_dates_year_min",""
"688","1","dropdown_dates","0"
"710","42","scale_export","0"
"709","42","random_order","0"
"708","42","public_statistics","0"
"707","42","page_break","0"
"706","42","multiflexible_checkbox","0"
"705","42","multiflexible_step",""
"704","42","multiflexible_min",""
"703","42","multiflexible_max",""
"702","42","hidden","0"
"701","42","array_filter_exclude",""
"700","42","array_filter",""
"699","42","answer_width",""
"698","41","text_input_width",""
"697","41","suffix",""

#
# ASSESSMENTS TABLE
#

#
# SURVEYS_LANGUAGESETTINGS TABLE
#
"surveyls_survey_id","surveyls_language","surveyls_title","surveyls_description","surveyls_welcometext","surveyls_endtext","surveyls_url","surveyls_urldescription","surveyls_email_invite_subj","surveyls_email_invite","surveyls_email_remind_subj","surveyls_email_remind","surveyls_email_register_subj","surveyls_email_register","surveyls_email_confirm_subj","surveyls_email_confirm","surveyls_dateformat"
"49528","en","a","","","","","","Invitation to participate in survey","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}","Reminder to participate in survey","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}","Survey registration confirmation","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}.","Confirmation of completed survey","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} at {ADMINEMAIL}.<br /><br />Sincerely,<br /><br />{ADMINNAME}","1"

#
# QUOTA TABLE
#

#
# QUOTA_MEMBERS TABLE
#

#
# QUOTA_LANGUAGESETTINGS TABLE
#

limesurvey_survey_49528.csv (4,956 bytes)   
Bug heat16
Complete LimeSurvey version number (& build)8429
I will donate to the project if issue is resolved
BrowserIE8 or Opera
Database type & versionMy SQL
Server OS (if known)Apache/2.2.14 (Unix)
Webserver software & version (if known)Apache/2.2.14 (Unix)
PHP VersionPHP Version 5.2.12

Relationships

related to 04368 closedMazi Date filter doesn't work in statistics 

Activities

lemeur

lemeur

2010-03-09 22:14

developer   ~11268

Last edited: 2010-03-09 22:28

First information Date questions are not supported in statistics.

Correction: I'm wrong. Date quesitons are not supported in the stats report, but are supported in the report query.

lemeur

lemeur

2010-03-09 22:42

developer   ~11270

I confirm the bug

lemeur

lemeur

2010-03-13 00:03

developer   ~11316

Hi Tim,
While investigating this bug I came to a strange code.

In statistics.php you build a $summary Array containing all the fieldnames to be displayed in the report: am I right ?

Then you call "generate_statistics($surveyid,$summary,$summary, ...)

The second parameter of this function is $allfields, which is used later around line 299:
if (in_array($pv, $allfields))
{
==> here is built the $selects[] array that is used for building the filter SQL query
}

But If I'm right, this means you can only filter responses on a specific answers IF AND ONLY IF the question is select for display !

Please I would really like to have your input on this as it will help fixing this bug.

Thanks in advance,
Thibault

lemeur

lemeur

2010-03-13 00:18

developer   ~11317

[00:15] <lemeur> $summary cannot be used a replacement for $allfields
[00:16] <lemeur> this is because $summary is only a list of question files prefixed with question type , and allfields is a list of filter fields
[00:16] <lemeur> for instance in summary for a numerical quesiton you'll have "N49528X1X41"
[00:17] <lemeur> but in allfileds you should have N49528X1X41G (for greater), ...
[00:17] <lemeur> anyway, there is a bug for sure

The above statement is true if we want to use $allfields as in line 300:
if (in_array($pv, $allfields))
{
==> build $selects[] array.
}

user6961

2010-03-29 07:03

  ~11530

Guys,

Excuse my ignorance but the current "feedback" staus of this item - does it mean the bug is not going to get fixed?

I am very eager to see this one sorted as it seriously affects the inbuilt response filtering feature use.

Cheers,
Ivor

lemeur

lemeur

2010-03-29 09:50

developer   ~11531

You're right the status should be set back to Confirmed.

Thibault

rakete

rakete

2010-04-01 21:33

reporter   ~11568

this form eats posts.

Thibault, can you provide me an example survey with answers to test some?

I think the problem is that these question types were added after the statistics_function.php and it was not updated accordingly. There is a lot of if($questionType==...) stuff.

Greetings

lemeur

lemeur

2010-04-04 09:56

developer   ~11582

Hi Tim,
Any survey with numerical and Date question will demonstrate the bug in the Statistics Filter.
See the attached survey, activate it, answer it with answer 10 and then 20 for the numerical question and then try in the stats filter to filter on numerical answer >= 15. The result is that you gett the 2 answers !

The Date and Numerical questions were added before the statistics_function.php file was added.

Please read my post 11317 as it gives the bug cause.

Also read my post 11316 as it focuses on another issue: you can only filter on a question which is selected for display which seems not logical.

TIA,
Thibault

Mazi

Mazi

2010-05-26 16:30

updater   ~11976

Last edited: 2010-05-26 16:31

A user just reported a similiar problem when trying to filter by a date question. We should try to fix this at the 1.90RC.

Machaven, you said you were working on statistics, can you have a look?

machaven

machaven

2010-05-27 08:51

reporter   ~12004

Fixed in SVN, i think numerical input was fixed by the date type fix, because its working :)

Issue History

Date Modified Username Field Change
2010-03-09 15:16 user6961 New Issue
2010-03-09 17:53 user372 Status new => assigned
2010-03-09 17:53 user372 Assigned To => lemeur
2010-03-09 22:14 lemeur Note Added: 11268
2010-03-09 22:28 lemeur Note Edited: 11268
2010-03-09 22:42 lemeur Note Added: 11270
2010-03-09 22:42 lemeur Status assigned => confirmed
2010-03-12 23:57 lemeur Issue Monitored: lemeur
2010-03-12 23:57 lemeur Status confirmed => assigned
2010-03-12 23:57 lemeur Assigned To lemeur => rakete
2010-03-13 00:03 lemeur Note Added: 11316
2010-03-13 00:03 lemeur Status assigned => feedback
2010-03-13 00:18 lemeur Note Added: 11317
2010-03-29 07:03 user6961 Note Added: 11530
2010-03-29 07:03 user6961 Status feedback => assigned
2010-03-29 09:50 lemeur Note Added: 11531
2010-03-29 09:50 lemeur Status assigned => confirmed
2010-04-01 21:33 rakete Note Added: 11568
2010-04-04 09:50 lemeur File Added: limesurvey_survey_49528.csv
2010-04-04 09:56 lemeur Note Added: 11582
2010-05-05 11:59 Mazi Status confirmed => assigned
2010-05-26 16:29 Mazi Target Version => 1.90RC1
2010-05-26 16:30 Mazi Note Added: 11976
2010-05-26 16:30 Mazi Assigned To rakete => machaven
2010-05-26 16:31 Mazi Note Edited: 11976
2010-05-26 17:05 jonasfiles Issue Monitored: jonasfiles
2010-05-26 17:19 Mazi Relationship added related to 04368
2010-05-27 08:51 machaven Note Added: 12004
2010-05-27 08:52 machaven Status assigned => resolved
2010-05-27 08:52 machaven Fixed in Version => 1.90RC1
2010-05-27 08:52 machaven Resolution open => fixed
2010-06-08 21:51 c_schmitz Status resolved => closed
2011-05-14 23:44 lliivviioo Issue Monitored: lliivviioo
2021-08-02 17:21 guest Bug heat 10 => 16