How to query multiple columns against a single array of ids

Question

I have the following model:

Message.rb: sender_id, receiver_id, created_at

I would like to find all messages where the sender_id and receiver_id are both within an array of ids [1,4,41,543,312,62,234]. I would then like to group all the messages by the pair (sender_id & receiver_id) ordered by created_at.

Is this the right way to write the query? I am looking for an optimal solution here.

Message.where("sender_id IN ? AND receiver_id IN ?", @ids)

Deepika · Accepted Answer · 2013-05-21 04:43:48Z

1

Try:-

Message.where("sender_id IN (?) AND receiver_id IN (?)", @ids, @ids).order("created_at ASC")

answered May 21, 2013 at 4:43

Deepika

8266 silver badges14 bronze badges

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

4 Comments

AnApprentice Over a year ago

Thanks but does that group by sender_id and receiver_id before the order by created_at?

Deepika Over a year ago

No it will not group your records.

Deepika Over a year ago

Try Message.where("sender_id IN (?) AND receiver_id IN (?)", @ids, @ids).group("sender_id,receiver_id").order("created_at ASC")

AnApprentice Over a year ago

Thanks I tried that but it errors with column "messages.id" must appear in the GROUP BY clause or be used in an aggregate function

Collectives™ on Stack Overflow

How to query multiple columns against a single array of ids

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related