Relationship Graph
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 |