How to prepare data from more tables for JqGrid in Rails app

Question

Hello, I have a problem with prepare data for JqGrid. I have used this plugin http://www.2dconcept.com/jquery-grid-rails-plugin and I need table with data from more models.

for example User model:

has_one :profile
has_many :users_roles
has_many :roles, :through=>:users_roles

and i need this data in jqGrid

[user.login, user.profile.email, user.roles.collect{|r| r.name}] 

Thanks for your answers.

Answer 1

Hi Suborx,

Just to be sure: The User <-> Roles relationship is a has_and_belongs_to_many, right? Because it looks like your avoiding the habtm by having "user_role"s and "roles through user_roles" specified.

I will work on displaying a habtm in a subgrid with exactly the plugin you use next week and post my solution here (if I find one).