11574: Search box in main survey list is case sensitive - LimeSurvey bugs and feature requests

This bug affects 1 person(s).

ID	Project	Category	View Status	Date Submitted	Last Update

11574	Bug reports	Survey editing	public	2016-08-23 15:24	2016-09-20 10:48

Reporter	aesteban	Assigned To	c_schmitz
Priority	none	Severity	minor
Status	closed	Resolution	fixed
Product Version	2.50.x
Fixed in Version	2.52.x

Summary	11574: 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
Tags	No tags attached.

Bug heat	4
Complete LimeSurvey version number (& build)	160817
I will donate to the project if issue is resolved	No
Browser	Firefox
Database type & version	postgresql 9.4
Server OS (if known)	Debian Jessie
Webserver software & version (if known)	nginx 1.6.2
PHP Version	5.6

User List	There are no users monitoring this issue.

c_schmitz 2016-08-24 10:04 administrator ~40411	That is dependant on the database engine. Postgres is always case-sensitive here.

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 2016-08-24 10:55 administrator ~40420	I am not sure how that solution would look like, but sure, knock yourself out ;)

aesteban 2016-08-26 00:25 developer ~40512	At least I will try :-)

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 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 2016-09-20 10:48 administrator ~40832	Version 2.52 Build 160920 released

LimeSurvey: master 52ecf96a 2016-09-10 15:15 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 16:03 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

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