ActiveRecord Question across Tables

Hi All,

I know the answer to this may be simple but I cannot think of it! First
let me explain the problem.

I have the following tables and relations:
log_entries <n…n> users
log_entries <n…1> users
users <n…n> groups

groups < residence1, residence2 (non-normalized by design)

I would like a way to get an array of user id’s (or user objects) from a
given log entry such that the array contains one element for each user
which is a member of a group which has a residence in common with the
user who created the log entry.

What I currently have is a messy list of code segments such as:

groups = self.user.groups

residences = []
groups.each do { |group|
residences << group.residence1
residences << group.residence2
}

users = []
residences.each do { |residence|

}

Can anyone please explain the best (or just a better) way of doing this
please. I am falling very much in love with Rails, it is the first
framework I have really got to grips with and have heard lots about its
great community!

Many thanks in advance,

James A.s

This forum is not affiliated to the Ruby language, Ruby on Rails framework, nor any Ruby applications discussed here.

| Privacy Policy | Terms of Service | Remote Ruby Jobs