ActiveRecord Query in another query, like "IN" with SQL

Question

i would like write this query in Rails/Active Record

SELECT *  FROM messages WHERE (realtor_id,created_at) IN  ( SELECT realtor_id, MAX(created_at),message   FROM messages   WHERE `messages`.`user_id` = 8   GROUP BY realtor_id );

I tried some syntaxes but it doesnt work... I think, the solution is near :

@discussions = Message.where(realtor_id: created_at: [Message.where(:user_id => current_user.id).select("realtor_id, MAX(created_at) as created_at").group("realtor_id").order("created_at ASC")])

Someone can help me ?

Thanks for advance,

F.

LHH · Accepted Answer · 2013-10-29 16:30:42Z

1

You can create sql query and pass in

query = "SELECT *  FROM messages WHERE (realtor_id,created_at) IN  ( SELECT realtor_id, MAX(created_at),message FROM messages WHERE `messages`.`user_id` = 8   GROUP BY realtor_id )"

@discussions = ActiveRecord::Base.connection.execute(query)

answered Oct 29, 2013 at 16:30

LHH

3,3231 gold badge24 silver badges29 bronze badges

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

Collectives™ on Stack Overflow

ActiveRecord Query in another query, like "IN" with SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related