Search not working right

when the search gets submitted it only returns results for records that
had
the searched value in publicists

from my model:
def self.search(search)
where(“headline LIKE ?”, “%#{search}%”)
where(“storyline LIKE ?”, “%#{search}%”)
where(“publicist LIKE ?”, “%#{search}%”)
end

from my controller:
def index
if params[:search]
@press_releases =
PressRelease.search(params[:search]).order(“dateline
DESC”)
else
@press_releases = PressRelease.order(“dateline DESC”)
end
end

On 7 December 2015 at 13:55, fugee ohu [email protected] wrote:

when the search gets submitted it only returns results for records that had
the searched value in publicists

from my model:
def self.search(search)
where(“headline LIKE ?”, “%#{search}%”)
where(“storyline LIKE ?”, “%#{search}%”)
where(“publicist LIKE ?”, “%#{search}%”)
end

The where method returns a set of matching records, your method runs
the first where() and throws the result away, then it does the same
with the second and throws the result away, then it runs the third and
returns that. You presumably wish to find records where any of three
are true so you need to use something like
where((“headline LIKE ? OR storyline LIKE ? OR publicist LIKE ?”,
“%#{search}%”, “%#{search}%”, “%#{search}%”)

Colin

Thanks Colin, the person who posted that code sure had me fooled, i
could
have done better myself without adding code to the model It looked like
an
advanced technique, who would have guessed it was so wrong

On 7 December 2015 at 16:15, fugee ohu [email protected] wrote:

Thanks Colin, the person who posted that code sure had me fooled, i could
have done better myself without adding code to the model It looked like an
advanced technique, who would have guessed it was so wrong

Where did you see it posted? Have you still got the link?

Colin

Also in the previous code, you can do ILIKE instead of like to get rid
case sensitivity. Just a FYI :slight_smile:

Where did you see it posted? Have you still got the link?
Colin

http://www.korenlc.com/creating-a-simple-search-in-rails-4/

On 7 December 2015 at 17:34, fugee ohu [email protected] wrote:

Where did you see it posted? Have you still got the link?
Colin

http://www.korenlc.com/creating-a-simple-search-in-rails-4/

If you read the comments you will see that others have pointed out the
error, though why it has not been corrected is beyond me.

Cheers

Colin

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs