# How would I find all "players" on an "active team"?

**URL:** <https://www.ruby-forum.com/t/how-would-i-find-all-players-on-an-active-team/155926>\
**Category:** Rails\
**Created:** [December 18, 2008, 7:57am UTC](https://www.ruby-forum.com/t/how-would-i-find-all-players-on-an-active-team/155926 "2008-12-18T07:57:38Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![adistarmid](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f14d63/32.png) [@adistarmid](https://www.ruby-forum.com/u/adistarmid)\
**Post date:** [December 18, 2008, 7:57am UTC](https://www.ruby-forum.com/t/how-would-i-find-all-players-on-an-active-team/155926/1 "2008-12-18T07:57:38Z")

</div>

I’m trying to find all players on an active team, and this is just  
stumping me.

I defined the “active team” by:

@active\_team = Team.find(:all, :conditions =\> [“active=?”, true])

Now, I’m trying to use in my loop:

@active\_team.players

but that just gives me an “undefined method `players’”. I know I’m  
probably missing something really simple. Any idea?

---

<div class="post-metadata">

**Author:** ![adistarmid](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f14d63/32.png) [@adistarmid](https://www.ruby-forum.com/u/adistarmid)\
**Post date:** [December 18, 2008, 8:22am UTC](https://www.ruby-forum.com/t/how-would-i-find-all-players-on-an-active-team/155926/2 "2008-12-18T08:22:52Z")

</div>

> @active\_team = Team.find(:all, :conditions =\> [“active=?”, true])

The result of find(:all,…) is an array

> Now, I’m trying to use in my loop:
> 
> @active\_team.players

You want @active\_team.each {|t| t.players}

or some such.

---

<div class="post-metadata">

**Author:** ![adistarmid](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f14d63/32.png) [@adistarmid](https://www.ruby-forum.com/u/adistarmid)\
**Post date:** [December 18, 2008, 8:24am UTC](https://www.ruby-forum.com/t/how-would-i-find-all-players-on-an-active-team/155926/3 "2008-12-18T08:24:09Z")

</div>

Do you have:

has\_many :players

in your Team model?

In order to access players in a team or team in Player object you must  
define relations in the model. In the later case it should be:

belongs\_to :team

On Dec 18, 7:57 am, Bob S. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid)

---

<div class="post-metadata">

**Author:** ![adistarmid](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/a/f14d63/32.png) [@adistarmid](https://www.ruby-forum.com/u/adistarmid)\
**Post date:** [December 18, 2008, 8:34am UTC](https://www.ruby-forum.com/t/how-would-i-find-all-players-on-an-active-team/155926/4 "2008-12-18T08:34:07Z")

</div>

Danny B. wrote:

> > @active\_team = Team.find(:all, :conditions =\> [“active=?”, true])
> 
> The result of find(:all,…) is an array
> 
> > Now, I’m trying to use in my loop:
> > 
> > @active\_team.players
> 
> You want @active\_team.each {|t| t.players}
> 
> or some such.

Hi Danny,

I tried the @active\_team.each {|t| t.players}, but it’s not working for  
me. It’s reading the contents of the Team model for some reason. Is  
there an alternative way that might work?