association beween model

rubyonrails-talk
1

hi maybe its a simple question, but i can't understand how to resolve it. i have a model user and contact. so a user can have many contact and contact belong to one user. so for now i want count the number of contact of the user. what i did is like this: count = ActiveRecord::Base.connection.select_one("select count(person_id) amis from contacts where user_id =" + user.id.to_s)

but i dont like this solutions cause the number of freind i will use it in a sortable table, and if this variable dont belong to the user params, i cant use it to sort the table :confused: thanks.

2

Hello,

In the controller, get the user in question, for example

@user = User.find(params[:id])

and then do

count = @user.contacts.count

Wael

3

thanks Wael :slight_smile: it make the half of work. the probleme now is when i use the gems handles_sortable_columns i can't sort the table with the count column cause the count field dont figure in the user table :S i didn't find a solution !!

4

Hey Adel,

I'm sorry I've never used this gem, but maybe try creating a count method on the user model.

Wael