habtm find question

The model "Raids" and "Characters" have a habtm relationship. I'm
having a tough time finding all the characters who have attended a
raid in the last week. I have a timestamp column in the raids table.

Its easy to grab all the raids each char has attended in the last week
but i cant think of how to get all the characters.

Thanks in advance.

You might want to use has_many :through and put the timestamp in join table.

Having the timestamp in the join table seems redundant and not very
rails like since the timestamp would be the same for every row which
points to a particular raid. while it would allow me to do something
has_many :recent_chars, :though => :join, :source =>:raid, :conditions
=> 'timestamp <= 1.week.ago' (assuming this is even correct)

with my inexperience i'm not sure if that is the best way to go about
doing things.