Search not working right

Rails
1

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

2

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

3

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

4

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

5

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

6

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

7

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

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