View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 6
IDProjectCategoryView StatusDate SubmittedLast Update
17219Bug reportsOtherpublic2021-03-31 14:372021-07-12 11:53
Reporterzufolo441 Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version4.4.15 
Summary17219: wrong field type detect in answers view list
Description

Hi, 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.
Bug heat6
Complete LimeSurvey version number (& build)4.4.15
I will donate to the project if issue is resolvedNo
BrowserFirefox 87
Database type & versionPostgreSQL 11.9
Server OS (if known)BSD 12.2
Webserver software & version (if known)Apache 2.4
PHP Version7.1.33

Users monitoring this issue

There are no users monitoring this issue.

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

Screenshot_20210331_172845.png (329,333 bytes)
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
c_schmitz

c_schmitz

2021-07-12 11:53

administrator   ~65329

Release done.

Related Changesets

LimeSurvey: master 5423d57d

2021-03-31 20:24

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 20:24

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
2021-07-12 11:53 c_schmitz Note Added: 65329
2021-07-12 11:53 c_schmitz Status resolved => closed