Forum: Ruby on Rails ActiveRecord query, dot notation for associations

Announcement (2017-05-07): is now read-only since I unfortunately do not have the time to support and maintain the forum any more. Please see and for other Rails- und Ruby-related community platforms.
merg (Guest)
on 2007-01-28 23:14
(Received via mailing list)
Am I missing something in Active record, or is there a plug-in
available which easily allows to use the 'dot-notation' in deeply
linked (that is, more then one link away) associations. Suppose I want
to count the posts in a blog of a certain user, can I write something
like :condition = ?

Elliott B. (Guest)
on 2007-01-29 04:42

I think that you might want to try this this.  I don't know if this will
work or not, but this is what I would experiment with:
In your post model define a new method called 'comments_by_user'
class post < ActiveRecord::Base
  has many :comments
  belongs_to :user

  def comments_by_user(user)
    comments = Comment.find(:conditions => ["user_id = ?  and post_id =


Invoke like this in your views:

<%= post.comments_by_user(user).count-%>

Lemme know if it works for you.

merg (Guest)
on 2007-01-30 12:51
(Received via mailing list)
Hi Andreas, this helps!!!!

I'm used to EJBQL and HQL wherel the dot-notation is common.


On Jan 29, 3:42 am, Elliott B. <removed_email_address@domain.invalid>
This topic is locked and can not be replied to.