View Issue Details

Related ChangesetsJump to NotesJump to History
This bug affects 1 person(s).
 4
IDProjectCategoryView StatusDate SubmittedLast Update
11574Bug reportsSurvey editingpublic2016-08-23 15:242016-09-20 10:48
Reporteraesteban Assigned Toc_schmitz  
PrioritynoneSeverityminor 
Status closedResolutionfixed 
Product Version2.50.x 
Fixed in Version2.52.x 
Summary11574: Search box in main survey list is case sensitive
Description

Search box in main survey list is case sensitive

Steps To Reproduce

Enter survey list windows
Create a survey with uppercase title
Search for this survey with lowercase string

TagsNo tags attached.
Bug heat4
Complete LimeSurvey version number (& build)160817
I will donate to the project if issue is resolvedNo
BrowserFirefox
Database type & versionpostgresql 9.4
Server OS (if known)Debian Jessie
Webserver software & version (if known)nginx 1.6.2
PHP Version5.6

Users monitoring this issue

There are no users monitoring this issue.

Activities

c_schmitz

c_schmitz

2016-08-24 10:04

administrator   ~40411

That is dependant on the database engine.
Postgres is always case-sensitive here.
aesteban

aesteban

2016-08-24 10:53

developer   ~40419

Since Postgresql is a officially supported DB, could not we implement some workaround? (I can do it if you agree)

Case insensitive search worked fine in 2.06 with Postgresql.
c_schmitz

c_schmitz

2016-08-24 10:55

administrator   ~40420

I am not sure how that solution would look like, but sure, knock yourself out ;)
aesteban

aesteban

2016-08-26 00:25

developer   ~40512

At least I will try :-)
aesteban

aesteban

2016-09-10 15:21

developer   ~40749

Last edited: 2016-09-10 15:22

@c_schmitz : My suggestion:

https://github.com/LimeSurvey/LimeSurvey/pull/535
c_schmitz

c_schmitz

2016-09-14 16:03

administrator   ~40778

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

c_schmitz

2016-09-20 10:48

administrator   ~40832

Version 2.52 Build 160920 released

Related Changesets

LimeSurvey: master 52ecf96a

2016-09-10 13:15:31

aesteban

Details Diff 		Fixed issue 11574: Search box in main survey list is case sensitive

Dev: Also fixing the same problem in tokens list		 Affected Issues
11574
add - application/core/LSDbCriteria.php Diff File
mod - application/models/Survey.php Diff File
mod - application/models/TokenDynamic.php Diff File

LimeSurvey: master 771c5027

2016-09-14 14:03:38

c_schmitz

Details Diff 		Merge pull request #535 from Aestu/case-insensitive-search-for-postgresql-2

Fixed issue 11574: Search box in main survey list is case sensitive		 Affected Issues
11574
add - application/core/LSDbCriteria.php Diff File
mod - application/models/Survey.php Diff File
mod - application/models/TokenDynamic.php Diff File

Issue History

Date Modified Username Field Change
2016-08-23 15:24 aesteban New Issue
2016-08-24 10:04 c_schmitz Note Added: 40411
2016-08-24 10:04 c_schmitz Status new => closed
2016-08-24 10:04 c_schmitz Assigned To => c_schmitz
2016-08-24 10:04 c_schmitz Resolution open => won't fix
2016-08-24 10:53 aesteban Assigned To c_schmitz =>
2016-08-24 10:53 aesteban Note Added: 40419
2016-08-24 10:53 aesteban Status closed => feedback
2016-08-24 10:53 aesteban Resolution won't fix => reopened
2016-08-24 10:53 aesteban Assigned To => c_schmitz
2016-08-24 10:53 aesteban Status feedback => assigned
2016-08-24 10:55 c_schmitz Note Added: 40420
2016-08-24 10:55 c_schmitz Assigned To c_schmitz => aesteban
2016-08-26 00:25 aesteban Note Added: 40512
2016-09-10 15:21 aesteban Note Added: 40749
2016-09-10 15:22 aesteban Note Edited: 40749
2016-09-14 16:03 aesteban Changeset attached => LimeSurvey master 52ecf96a
2016-09-14 16:03 c_schmitz Changeset attached => LimeSurvey master 771c5027
2016-09-14 16:03 c_schmitz Note Added: 40778
2016-09-14 16:03 c_schmitz Assigned To aesteban => c_schmitz
2016-09-15 15:26 c_schmitz Status assigned => resolved
2016-09-15 15:26 c_schmitz Resolution reopened => fixed
2016-09-15 15:26 c_schmitz Fixed in Version => 2.52.x
2016-09-20 10:48 c_schmitz Note Added: 40832
2016-09-20 10:48 c_schmitz Status resolved => closed
2019-11-01 17:25 c_schmitz Category Survey design => Survey editing