Rails query string with scope param

Question

As per the often cited Justin Weiss article on scopes. The goal is that the titles of Articles can be searched by keyword, so that the query string ?title=kayne populates @articles.title with articles with kayne in the title.

class Article < Active Record::Base
  .
  .
  scope :title, -> (title) { where("title like ?", "%#{title}%")}
end

class ArticlesController < ApplicationController
  def index 
    @articles = Article.all
    @articles = @articles.title if params[:title].present? 
  end
end

Heroku Log
Parameters: {"title"=>"kayne"}
: Completed 500 Internal Server Error in 1ms (ActiveRecord: 0.0ms)
: ArgumentError (wrong number of arguments (0 for 1)):

from the Justin Weiss article... example.com/products?status=active&starts_with=Ruby.. my query string is... example.com/articles?title=kayne ... this does not pass any param to the scope? please advise. — Timmy Von Heiss
– Timmy Von Heiss, Commented Jun 29, 2016 at 0:18

Sapna Prajapati · Accepted Answer · 2016-06-29 08:11:13Z

1

With respect to your question that it requires to pass first words from sentense, please find my inputs as below:

scope :title, -> (title) { where("title like ?", "%#{title}%")}

When using Like operator it will fetch all matching records from entire sentense, doesn't bothering starting word or ending word.

It will returns all the records with empty params so in that case no need to check params present or not.

answered Jun 29, 2016 at 8:11

Sapna Prajapati

616 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Timmy Von Heiss Over a year ago

This is working. Is there a way to make it so that capitalization does not matter? Right now it will only return Fried if you query for Fried. Thanks.

Timmy Von Heiss Over a year ago

the above can be achieved by substituting ILIKE for like.

Sapna Prajapati Over a year ago

scope :title, -> (title) { where("title ilike ?", "%#{title}%")} - The key word ILIKE can be used instead of LIKE to make the match case-insensitive.

oreoluwa · Accepted Answer · 2016-06-29 00:18:54Z

0

class ArticlesController < ApplicationController
  def index 
    @articles = Article.all
    @articles = @articles.title(params[:title]) if params[:title].present? 
  end
end

answered Jun 29, 2016 at 0:18

oreoluwa

5,6532 gold badges22 silver badges28 bronze badges

1 Comment

Timmy Von Heiss Over a year ago

I guess this works however it only works if I am searching for the first word in the title... So for a title of Fried Eggs it only works if I pass the param of Fried.. even fried does not work... is there a way to do this so that it will work like a normal keyword search and not be limited to the very first word of the title string?

Collectives™ on Stack Overflow

Rails query string with scope param

2 Answers 2

3 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related