Who can fix my query syntax?

rubyonrails-talk
1

Hi there,

is there somebody who could help me out with the correct query syntax?

The situation is the following:

MODELS:

2

Hi there,

is there somebody who could help me out with the correct query syntax?

The situation is the following:

MODELS:

user has_many :memberships

user has_many :groups,               :through => :memberships,               :source => :group

TABLES:

users: - id

memberships: - id - user_id - group_id - accepted (true/false)

groups: - id

=> What I need is the collection of groups ("@groups") for a user, but only if the "memberships" have "true" in the column "accepted".

I started with something like this (but don't know how to fix the conditions part):

@groups = @user.groups.find(:all, :conditions => { "the memberships must have 'true' in the 'accepted' column" })

3

Craig White wrote:

memberships:

I started with something like this (but don't know how to fix the conditions part):

@groups = @user.groups.find(:all, :conditions => { "the memberships must have 'true' in the 'accepted' column" })

---- @user = User.find($SomeIdNumber) @groups = Group.find(:all, :conditions => ["accepted IS TRUE AND user_id = ?", @user])

Craig

Hey Craig,

thanks for your answer! One question back though:

In your 'conditions' statement: doesn't "accepted" refer to the 'group' table? I'm asking because the tricky part in my case is: "accepted" refers to/exists only in the 'membership' table... (see above: the model is: user has_many :groups, :through => :memberships, :source => :group)

Tom

4

You can use the :conditions option:

  has_many :accepted_groups, :through => :memberships, :source => :group,     :conditions => ['memberships.accepted =?', true]