I have an SQL query that returns what I need, but I'm having trouble converting this into an active record query the "Rails way".
My SQL query is:
SELECT * from trips
WHERE trips.title LIKE "%Thailand%"
AND EXISTS (SELECT * from places WHERE places.trip_id = trips.id AND places.name LIKE "%Bangkok%")
AND EXISTS (SELECT * from places WHERE places.trip_id = trips.id AND places.name LIKE "%Phuket%")
I'm trying something like this using Rails:
@trips=Trip.where("trips.title LIKE ?", "%Thailand%")
@trips=@trips.includes(:places).where(("places.name LIKE ?","%Bangkok%").exists?) => true, ("places.name LIKE ?","%Phuket%").exists?) => true)
But it doesn't seem to work and i'm stumped as to what to try.
Aucun commentaire:
Enregistrer un commentaire