How to get the readers of 2 specific articles ?

rubyonrails-talk
1

User.find(:all, :include=>:articles, :conditions=>["articles.id in (?)", [a1.id, a2.id].join(',')])

2

AndyV wrote:

User.find(:all, :include=>:articles, :conditions=>["articles.id in (?)", [a1.id, a2.id].join(',')])

On Feb 26, 4:37 pm, Harry Seldon <rails-mailing-l...@andreas-s.net>

It works well. Thx a lot !

3

Congrats!

4

I tested this too quickly. Now that I come back to this it appears that it is actually not working.

The command User.find(:all, :include=>:articles, :conditions=>["articles.id in (?)", [a1.id, a2.id].join(',')]) returns the users who read one of the two articles but not only the users who read both.

Any idea of how to get simply the users who read both articles ?

Thx H

AndyV wrote:

5

Harry Seldon wrote:

Any idea of how to get simply the users who read both articles ?

Have a look at this thread:

Various solutions to effectively the same problem.

6

Thx, actually I have already seen this thread but clearly there is nothing "simple" in it.

This comes back to the question what is the SQL squery to get the users who read both articles.

For the moment I will simply do the intersection r1 & r2. It seems that Rails cannot do much for this question. So I will use SQL when I have some time.

Thx H

Mark Bush wrote: