summaryrefslogtreecommitdiff
path: root/app/models
diff options
context:
space:
mode:
authormo khan <mo@mokhan.ca>2014-10-19 09:52:12 -0600
committermo khan <mo@mokhan.ca>2014-10-19 09:52:12 -0600
commitbd053ea6aebfe1ca2b5348217ee5876ff7e80118 (patch)
treec4a235f23198dfea6465ddf9d938a022b0b39b05 /app/models
parent6fda7ad141fdf0129c57b30340c043b7e15167a9 (diff)
tie current category, sort to search.
Diffstat (limited to 'app/models')
-rw-r--r--app/models/creation/repository.rb2
1 files changed, 1 insertions, 1 deletions
diff --git a/app/models/creation/repository.rb b/app/models/creation/repository.rb
index 5948d41f..8d93ebd8 100644
--- a/app/models/creation/repository.rb
+++ b/app/models/creation/repository.rb
@@ -2,7 +2,7 @@ class Creation
include Queryable
scope :tagged, ->(tag) { tagged_with([tag]).where('photos_count > 0') }
scope :published, ->() { unscoped.distinct.includes(:user, :photos).joins(:photos).where('photos.image_processing' => nil) }
- scope :search, ->(query) { where(["upper(creations.name) like :query OR upper(creations.story) like :query", { query: "%#{query.upcase}%" }]) }
+ scope :search, ->(query) { where(["UPPER(creations.name) LIKE :query OR UPPER(creations.story) LIKE :query", { query: "%#{query.upcase}%" }]) }
class Repository < SimpleDelegator
def initialize(connection = Creation)