04290: Statistics: when using multiple questions to filter, all but the first are ignored

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

04290	Bug reports	Other	public	2010-04-22 19:00	2010-05-21 19:05

Reporter	jeboyd	Assigned To	texens
Priority	urgent	Severity	partial_block
Status	closed	Resolution	fixed
Product Version	1.87

Summary	04290: Statistics: when using multiple questions to filter, all but the first are ignored
Description	I have built a large survey with 420 questions which works great ... thanks much for the great software! The statistics feature works great when displaying a question result using just one filtering question. However, when I use more than one filtering question (as shown in the LimeSurvey documentation, http://docs.limesurvey.org/tiki-index.php?page=Statistics&structure=English+Instructions+for+LimeSurvey) all filtering questions after the first one are ignored. I am aware that there is a known bug that requires that all question checkboxes must be checked (even though the documentation doesn't show it that way) but multiple filters don't work for me with or without checking the boxes. The very weird thing is that multiple filters works fine when I try your online demo using active survey "Generic"!!! But it doesn't work with my database ... could the size of my survey (420 questions) have anything to do with it??? I really need this feature working. My survey is looking great (all 420 questions) but the unreliability of this filter feature will cause a lack of confidence in my project. Please help. TIA
Tags	No tags attached.
Attached Files	limesurvey_survey_37494.csv (8,249 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" "37494","1","Jim Boyd","Y","","","jim@hatterasdesigns.net","Y","","G","default","en","","N","N","0","N","Y","0","N","Y","N","N","N","2010-04-24","N","N","N","Y","N","N","D","N","jim@hatterasdesigns.net","","","15" # # GROUPS TABLE # "gid","sid","group_name","group_order","description","language" "766","37494","g1","0","","en" "767","37494","g2","1","","en" # # QUESTIONS TABLE # "qid","sid","gid","type","title","question","preg","help","other","mandatory","lid","lid1","question_order","language" "2698","37494","766","M","g1.1","g1.1<br />","","","N","N","0","0","0","en" "2699","37494","766","M","g1.2","g1.2<br />","","","N","N","0","0","1","en" "2700","37494","767","G","g2.1","g2.1<br />","","","N","N","0","0","0","en" "2701","37494","767","Y","g2.2","g2.2<br />","","","N","N","0","0","1","en" "2702","37494","767","M","g2.3","g2.3<br />","","","N","N","0","0","2","en" "2703","37494","766","S","g1.3","g1.3<br />","","","N","N","0","0","2","en" "2704","37494","767","T","g2.4","g2.4<br />","","","N","N","0","0","3","en" "2705","37494","767","L","g2.5","g2.5<br />","","","N","N","0","0","4","en" # # ANSWERS TABLE # "qid","code","answer","default_value","assessment_value","sortorder","language" "2705","1","1","N","0","1","en" "2705","2","2","N","0","2","en" "2698","1","1","N","0","1","en" "2698","2","2","N","0","2","en" "2699","1","1","N","0","1","en" "2699","2","2","N","0","2","en" "2702","1","1","N","0","1","en" "2702","2","2","N","0","2","en" # # CONDITIONS TABLE # # # LABELSETS TABLE # # # LABELS TABLE # # # QUESTION_ATTRIBUTES TABLE # "qaid","qid","attribute","value" "1533","2698","array_filter","" "1534","2698","array_filter_exclude","" "1535","2698","display_columns","1" "1536","2698","exclude_all_others","" "1537","2698","hide_tip","0" "1538","2698","hidden","0" "1539","2698","max_answers","" "1540","2698","min_answers","" "1541","2698","other_numbers_only","0" "1542","2698","other_replace_text","" "1543","2698","page_break","0" "1544","2698","public_statistics","0" "1545","2698","random_order","0" "1546","2698","scale_export","0" "1547","2699","array_filter","" "1548","2699","array_filter_exclude","" "1549","2699","display_columns","1" "1550","2699","exclude_all_others","" "1551","2699","hide_tip","0" "1552","2699","hidden","0" "1553","2699","max_answers","" "1554","2699","min_answers","" "1555","2699","other_numbers_only","0" "1556","2699","other_replace_text","" "1557","2699","page_break","0" "1558","2699","public_statistics","0" "1559","2699","random_order","0" "1560","2699","scale_export","0" "1561","2700","display_columns","1" "1562","2700","hidden","0" "1563","2700","page_break","0" "1564","2700","public_statistics","0" "1565","2700","scale_export","0" "1566","2701","hidden","0" "1567","2701","page_break","0" "1568","2701","public_statistics","0" "1569","2701","scale_export","0" "1570","2702","array_filter","" "1571","2702","array_filter_exclude","" "1572","2702","display_columns","1" "1573","2702","exclude_all_others","" "1574","2702","hide_tip","0" "1575","2702","hidden","0" "1576","2702","max_answers","" "1577","2702","min_answers","" "1578","2702","other_numbers_only","0" "1579","2702","other_replace_text","" "1580","2702","page_break","0" "1581","2702","public_statistics","0" "1582","2702","random_order","0" "1583","2702","scale_export","0" "1584","2703","display_rows","" "1585","2703","hidden","0" "1586","2703","maximum_chars","" "1587","2703","numbers_only","0" "1588","2703","page_break","0" "1589","2703","prefix","" "1590","2703","suffix","" "1591","2703","text_input_width","" "1592","2703","time_limit","" "1593","2703","time_limit_action","1" "1594","2703","time_limit_message","" "1595","2703","time_limit_message_delay","" "1596","2703","time_limit_disable_next","0" "1597","2703","time_limit_message_style","" "1598","2703","time_limit_timer_style","" "1599","2703","time_limit_warning","" "1600","2703","time_limit_warning_display_time","" "1601","2703","time_limit_warning_message","" "1602","2703","time_limit_warning_style","" "1603","2704","display_rows","" "1604","2704","hidden","0" "1605","2704","maximum_chars","" "1606","2704","page_break","0" "1607","2704","text_input_width","" "1608","2704","time_limit","" "1609","2704","time_limit_action","1" "1610","2704","time_limit_message","" "1611","2704","time_limit_message_delay","" "1612","2704","time_limit_disable_next","0" "1613","2704","time_limit_message_style","" "1614","2704","time_limit_timer_style","" "1615","2704","time_limit_warning","" "1616","2704","time_limit_warning_display_time","" "1617","2704","time_limit_warning_message","" "1618","2704","time_limit_warning_style","" "1619","2705","alphasort","0" "1620","2705","array_filter","" "1621","2705","array_filter_exclude","" "1622","2705","display_columns","1" "1623","2705","hide_tip","0" "1624","2705","hidden","0" "1625","2705","other_comment_mandatory","0" "1626","2705","other_numbers_only","0" "1627","2705","other_replace_text","" "1628","2705","page_break","0" "1629","2705","public_statistics","0" "1630","2705","random_order","0" "1631","2705","scale_export","0" # # 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" "37494","en","test survey - use for testing multiple filters using type=M&P questions","","","","","","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_37494.csv (8,249 bytes)

Bug heat	16
Complete LimeSurvey version number (& build)	8518
I will donate to the project if issue is resolved
Browser
Database type & version
Server OS (if known)
Webserver software & version (if known)
PHP Version

User List	There are no users monitoring this issue.

jeboyd 2010-04-22 23:01 reporter ~11632	Thanks to all for responding to my pleadings. I have done more testing after upgrading from 1.86 to 1.87 and I was wrong about 1.87. THE MULTIPLE FILTERS WORK FINE IN 1.87 (even for my huge 420 question survey), AS LONG AS YOU CHECK THE QUESTION BOXES for all involved questions. Call off the dogs and CANCEL THIS BUG REPORT ... FALSE ALARM, Please accept my apology and keep up the good work!

c_schmitz 2010-04-25 14:16 administrator ~11650	Why is this closed?

jeboyd 2010-04-25 17:55 reporter ~11654	Just to clarify, this bug report is not totally a duplicate of 4294, in that 4294 corrects this report to say that only type=M&P filter questions have the problem. Multiple filters using other question types work just fine.

Mazi 2010-04-25 18:29 updater ~11655	The bug was closed because the user reported that the problem was solved. I can reproduce bug 04294. When having two multiple choice questions and applying filters to both the filter at the second question doesn't work accordingly. @jeboys, can you please attach your sample survey here for testing!? Thanks.

c_schmitz 2010-04-25 19:02 administrator ~11656	A workaround doesn't mean it is solved :-).

jeboyd 2010-04-27 00:11 reporter ~11661	Guys, I found the bug and fixed it (see below). One line of code to reset a variable called $mselects in statistics_function.php will do it. Multiple type=m&P filters test out fine after the fix. Thanks again for allowing me to use this great software on my project. Jim Patch goes in statistics_function.php: `if ($mselects) { $thismulti=implode(" OR ", $mselects); $selects[]="($thismulti)"; $mselects=""; // THIS IS THE ONE LINE OF CODE }`

Mazi 2010-05-05 11:59 updater ~11713	Texens, this is the bug we talked about yesterday. Maybe you can take a look. Thanks!

texens 2010-05-05 23:05 reporter ~11716	Fix commited to r8692. Thanks jeboyd for bugreport and the patch !

lemeur 2010-05-21 19:05 developer ~11938	1.90 beta3 release

Date Modified	Username	Field	Change
2010-04-22 19:00	jeboyd	New Issue
2010-04-22 23:01	jeboyd	Note Added: 11632
2010-04-23 01:43	Mazi	Status	new => closed
2010-04-23 01:43	Mazi	Assigned To	=> Mazi
2010-04-23 01:43	Mazi	Resolution	open => no change required
2010-04-25 14:16	c_schmitz	Note Added: 11650
2010-04-25 14:16	c_schmitz	Status	closed => feedback
2010-04-25 14:16	c_schmitz	Resolution	no change required => reopened
2010-04-25 14:17	c_schmitz	Relationship added	has duplicate 04294
2010-04-25 14:17	c_schmitz	Project	@2@ => Bug reports
2010-04-25 17:55	jeboyd	Note Added: 11654
2010-04-25 17:55	jeboyd	Status	feedback => assigned
2010-04-25 18:29	Mazi	Note Added: 11655
2010-04-25 18:30	Mazi	Assigned To	Mazi => c_schmitz
2010-04-25 18:30	Mazi	Status	assigned => feedback
2010-04-25 18:45	jeboyd	Issue Monitored: jeboyd
2010-04-25 18:46	jeboyd	Issue End Monitor: jeboyd
2010-04-25 18:47	jeboyd	File Added: limesurvey_survey_37494.csv
2010-04-25 18:48	jeboyd	Issue Monitored: jeboyd
2010-04-25 18:51	Mazi	Status	feedback => assigned
2010-04-25 19:02	c_schmitz	Note Added: 11656
2010-04-27 00:11	jeboyd	Note Added: 11661
2010-05-01 15:03	jeboyd	Issue End Monitor: jeboyd
2010-05-05 11:59	Mazi	Assigned To	c_schmitz => texens
2010-05-05 11:59	Mazi	Note Added: 11713
2010-05-05 23:05	texens	Note Added: 11716
2010-05-05 23:05	texens	Status	assigned => resolved
2010-05-05 23:05	texens	Resolution	reopened => fixed
2010-05-21 19:05	lemeur	Note Added: 11938
2010-05-21 19:05	lemeur	Status	resolved => closed
2021-03-08 20:08	c_schmitz	Category	Statistics => (No Category)

View Issue Details

Relationships

Users monitoring this issue

Activities

Issue History