View Issue Details

IDProjectCategoryView StatusLast Update
17219Bug reportsOtherpublic2021-03-31 18:25
Reporterzufolo441 Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status resolvedResolutionfixed 
Product Version4.4.15 
Summary17219: wrong field type detect in answers view list
DescriptionHi, when I try to filter answers by an integer field I obtain an error:

SELECT COUNT(*) FROM "lime_survey_683358" "t" WHERE "683358X22X479" LIKE :ycp0
ERROR: operator does not exist: numeric ~~ unknown

That field is an integer, so the LIKE operator isn't available in PostgreSQL.

Thanks!
Steps To Reproduce
list answers and try to filter an integer field.
TagsNo tags attached.
Complete LimeSurvey version number (& build)4.4.15
I will donate to the project if issue is resolvedNo
BrowserFirefox 87
Database & DB-VersionPostgreSQL 11.9
Server OS (if known)BSD 12.2
Webserver software & version (if known)Apache 2.4
PHP Version7.1.33

Activities

DenisChenu

DenisChenu

2021-03-31 15:10

developer   ~63749

Way to reproduce :

1. LSS
2. Page where you see it
zufolo441

zufolo441

2021-03-31 17:29

reporter   ~63764

index.php/admin/responses/sa/browse/surveyid/$surveyID
c_schmitz

c_schmitz

2021-03-31 18:24

administrator   ~63765

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

c_schmitz

2021-03-31 18:25

administrator   ~63766

Fix committed to 3.x-LTS branch: http://bugs.limesurvey.org/plugin.php?page=Source/view&id=31437

Related Changesets

LimeSurvey: master 5423d57d

2021-03-31 18:24:37

c_schmitz

Details Diff
Fixed issue 17219: Filter on numeric fields in response view does not work on Postgres Affected Issues
17219
mod - application/controllers/admin/responses.php Diff File
mod - application/models/SurveyDynamic.php Diff File

LimeSurvey: 3.x-LTS dccd862f

2021-03-31 18:24:37

c_schmitz

Details Diff
Fixed issue 17219: Filter on numeric fields in response view does not work on Postgres Affected Issues
17219
mod - application/controllers/admin/responses.php Diff File
mod - application/models/SurveyDynamic.php Diff File

Issue History

Date Modified Username Field Change
2021-03-31 14:37 zufolo441 New Issue
2021-03-31 15:10 DenisChenu Note Added: 63749
2021-03-31 17:29 zufolo441 Note Added: 63764
2021-03-31 17:29 zufolo441 File Added: Screenshot_20210331_172845.png
2021-03-31 18:24 c_schmitz Changeset attached => LimeSurvey master 5423d57d
2021-03-31 18:24 c_schmitz Note Added: 63765
2021-03-31 18:24 c_schmitz Assigned To => c_schmitz
2021-03-31 18:24 c_schmitz Resolution open => fixed
2021-03-31 18:25 c_schmitz Status new => resolved
2021-03-31 18:25 c_schmitz Changeset attached => LimeSurvey 3.x-LTS dccd862f
2021-03-31 18:25 c_schmitz Note Added: 63766