View Issue Details

This bug affects 1 person(s).
 4
IDProjectCategoryView StatusLast Update
18358Bug reportsStatisticspublic2022-09-28 19:13
ReporterKapilSabarwal Assigned Togabrieljenik  
PrioritynoneSeverityminor 
Status ready for testingResolutionopen 
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.
Bug heat4
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 new When encrypted, some question types can't be filtered on statistics screen 

Users monitoring this issue

User List There are no users monitoring this issue.

Activities

KapilSabarwal

KapilSabarwal

2022-09-16 14:32

reporter  

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

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