View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 04189 | Bug reports | Statistics | public | 2010-03-09 15:16 | 2011-05-14 23:44 |
| Reporter | Assigned To | machaven | |||
| Priority | normal | Severity | partial_block | ||
| Status | closed | Resolution | fixed | ||
| Product Version | 1.87+ | ||||
| Target Version | 1.90RC1 | Fixed in Version | 1.90RC1 | ||
| Summary | 04189: 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. | ||||
| Tags | No 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
#
| ||||
| Bug heat | 16 | ||||
| Complete LimeSurvey version number (& build) | 8429 | ||||
| I will donate to the project if issue is resolved | |||||
| Browser | IE8 or Opera | ||||
| Database type & version | My SQL | ||||
| Server OS (if known) | Apache/2.2.14 (Unix) | ||||
| Webserver software & version (if known) | Apache/2.2.14 (Unix) | ||||
| PHP Version | PHP Version 5.2.12 | ||||
|
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. |
|
|
I confirm the bug |
|
|
Hi Tim, 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: 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, |
|
|
[00:15] <lemeur> $summary cannot be used a replacement for $allfields The above statement is true if we want to use $allfields as in line 300: |
|
|
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, |
|
|
You're right the status should be set back to Confirmed. Thibault |
|
|
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 |
|
|
Hi Tim, 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, |
|
|
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? |
|
|
Fixed in SVN, i think numerical input was fixed by the date type fix, because its working :) |
|
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2010-03-09 15:16 |
|
New Issue | |
| 2010-03-09 17:53 |
|
Status | new => assigned |
| 2010-03-09 17:53 |
|
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 |
|
Note Added: 11530 | |
| 2010-03-29 07:03 |
|
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 |