search for: reports_sorts

Displaying 1 result from an estimated 1 matches for "reports_sorts".

2006 Feb 28
8
HABTM count table
...s_to_many :reports end class Report < ActiveRecord::Base has_and_belongs_to_many :region has_and_belongs_to_many :subjects has_and_belongs_to_many :sorts end And i would like to get a count like @sort.reports.count The problem is get this query: SELECT COUNT(*) FROM reports WHERE (reports_sorts.sort_id = 6003 ) He uses the wrong table "reports" instead of the join table "reports_sorts". But it is in the where clause. Thanks in advance, Martijn