View Issue Details

This bug affects 1 person(s).
 6
IDProjectCategoryView StatusLast Update
18358Bug reportsStatisticspublic2022-11-01 10:59
ReporterKapilSabarwal Assigned Togabrieljenik  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version5.3.x 
Summary18358: Statistics filter feature is not working properly
Description

The result is not coming out when I select one particular question and select one particular sub-answer...and want to check the statistics of one particular answer.

Steps To Reproduce

####steps to reproduce-
1) Click on any survey with collected responses.
2) statistics>response filter>select questions and answer. > view statistics.

Expected result-

the accurate result of what I have selected, 95 participants have selected that answer...

Actual result-

but the answer is zero instead of 95

TagsNo tags attached.
Attached Files
Bug heat6
Complete LimeSurvey version number (& build) 5.3.31
I will donate to the project if issue is resolvedNo
Browserfirefox/chrome
Database type & version447
Server OS (if known)
Webserver software & version (if known)
PHP VersionN/A

Relationships

related to 18378 confirmed Response browsing filters are not working properly with encrypted attributes 
related to 18379 acknowledged When encrypted, some question types can't be filtered on statistics screen 

Users monitoring this issue

There are no users monitoring this issue.

Activities

gabrieljenik

gabrieljenik

2022-09-21 21:48

manager   ~71879

Couldn't reproduce it. Need LSA or help reproducing it :)

Thanks

gabrieljenik

gabrieljenik

2022-09-26 23:23

manager   ~71961

For encrypted attributes, filtergin requires encrypting values for the query.
Only did for single choice and multiple choice.

PR: https://github.com/LimeSurvey/LimeSurvey/pull/2635

For the other attribute types or forms of comparison, it is very difficult (if imposible) to query encrypted values.
Maybe, if an attribute is encrypted and is not single choice or multiple choice, we don't allow filtering?

Same will happen when browsing responses.

DenisChenu

DenisChenu

2022-09-27 08:23

developer   ~71964

For the other attribute types or forms of comparison, it is very difficult (if imposible) to query encrypted values.

Why ? We don't use compare ? A link to the search ?

Maybe, if an attribute is encrypted and is not single choice or multiple choice, we don't allow filtering?

yes , need this option if previous one is not set.

gabrieljenik

gabrieljenik

2022-09-27 14:33

manager   ~71971

For the other attribute types or forms of comparison, it is very difficult (if imposible) to query encrypted values.

Why ? We don't use compare ? A link to the search ?

For open text, If you need to query with wildcards it may not be possible. You may need to query by exact match... even spaces could bother in the query.
For numbers, if you need to query greater or lower than, porbably is not possible.

@ollehar what shall we do here?

DenisChenu

DenisChenu

2022-09-27 15:08

developer   ~71976

For open text, If you need to query with wildcards it may not be possible. You may need to query by exact match... even spaces could bother in the query.

Oh, yes … i'm silly

For numbers, if you need to query greater or lower than, porbably is not possible.

Same, i'm silly … you can remove the probably

gabrieljenik

gabrieljenik

2022-10-20 17:26

manager   ~72369

For encrypted attributes, filtergin requires encrypting values for the query.
Only did for single choice and multiple choice.

Tickets created for other type of questions.

gabrieljenik

gabrieljenik

2022-10-24 18:13

manager   ~72392

Fix committed to master branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=33987

LimeBot

LimeBot

2022-11-01 10:59

administrator   ~72505

Fixed in Release 5.4.9+221101

Related Changesets

LimeSurvey: master 9cd57df0

2022-10-24 20:13

gabrieljenik

Committer: GitHub


Details Diff
Fixed issue 18358: Statistics filter feature is not working properly (#2635) Affected Issues
18358
mod - application/helpers/admin/statistics_helper.php Diff File

Issue History

Date Modified Username Field Change
2022-09-16 14:32 KapilSabarwal New Issue
2022-09-16 14:32 KapilSabarwal File Added: statistics feature screenshot 1.png
2022-09-16 14:32 KapilSabarwal File Added: statistics filter screenshot 2.png
2022-09-16 14:32 KapilSabarwal File Added: statistics wrong result screenshot 3.png
2022-09-16 14:32 KapilSabarwal File Added: statistics feature screenshot 4.png
2022-09-21 21:48 gabrieljenik Assigned To => gabrieljenik
2022-09-21 21:48 gabrieljenik Status new => feedback
2022-09-21 21:48 gabrieljenik Note Added: 71879
2022-09-21 21:48 gabrieljenik Bug heat 0 => 2
2022-09-26 23:23 gabrieljenik Assigned To gabrieljenik => DenisChenu
2022-09-26 23:23 gabrieljenik Status feedback => ready for code review
2022-09-26 23:23 gabrieljenik Note Added: 71961
2022-09-27 08:23 DenisChenu Note Added: 71964
2022-09-27 08:23 DenisChenu Bug heat 2 => 4
2022-09-27 10:39 DenisChenu Status ready for code review => in code review
2022-09-27 14:33 gabrieljenik Note Added: 71971
2022-09-27 14:34 gabrieljenik Issue cloned: 18378
2022-09-27 14:34 gabrieljenik Relationship added related to 18378
2022-09-27 15:08 DenisChenu Note Added: 71976
2022-09-27 19:48 gabrieljenik Issue cloned: 18379
2022-09-27 19:48 gabrieljenik Relationship added related to 18379
2022-09-28 19:13 gabrieljenik Assigned To DenisChenu => gabrieljenik
2022-09-28 19:13 gabrieljenik Status in code review => ready for testing
2022-10-20 17:26 gabrieljenik Assigned To gabrieljenik => ollehar
2022-10-20 17:26 gabrieljenik Status ready for testing => ready for merge
2022-10-20 17:26 gabrieljenik Note Added: 72369
2022-10-24 18:13 gabrieljenik Changeset attached => LimeSurvey master 9cd57df0
2022-10-24 18:13 gabrieljenik Note Added: 72392
2022-10-24 18:13 gabrieljenik Assigned To ollehar => gabrieljenik
2022-10-24 18:13 gabrieljenik Resolution open => fixed
2022-11-01 10:59 LimeBot Note Added: 72505
2022-11-01 10:59 LimeBot Status ready for merge => closed
2022-11-01 10:59 LimeBot Bug heat 4 => 6