Patch #27122

Case insensitive filter for version name

Added by Nastya Fedorova 2 months ago. Updated about 1 month ago.

Status:NewStart date:
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Roadmap
Target version:4.1.0

Description

Search for version name does not work for case sensitive names

Case_sensitive_filter_for_version_name_.patch Magnifier (622 Bytes) Nastya Fedorova, 2017-10-04 15:17

History

#1 Updated by Anonymous 2 months ago

  • File photo_2017-09-01_22-08-39.jpg added

#2 Updated by Holger Just 2 months ago

There is a database-agnostic helper method for a case-insensititive LIKE. You should be able to just use this:

where([Redmine::Database.like("Version.table_name}.name", '?'), pattern])

MySQL is case-insensitive by default. Searching on Postgres should work with this method. As for the other supported databases: I'm not fully sure whether they do the right thing there. If they don't show the correct behavior then the Redmine::Database.like method should be fixed.

#3 Updated by Mischa The Evil about 1 month ago

  • File deleted (photo_2017-09-01_22-08-39.jpg)

#4 Updated by Toshi MARUYAMA about 1 month ago

  • Category changed from Search engine to Roadmap
  • Target version set to 4.1.0

Also available in: Atom PDF