Hi all,
I've a two simple table, resource
First of all, the condition you want to implement should be in the controller, not in the view. You can to use eager loading and a condition to only load the resource in question (most likely defined by a id value in the request params) and the associated projects in one SQL query with Active Record. then in your view you loop through those projects and show them
it would go something like this:
#Controller def proj @resource =Resource.find(params[:id], :include => :projects) end
#proj.rhtml <h1>Projects of Resource: <%= @resource.name %></h1> <table border="1"> <tr> <td width="30%"><p align="center"><i><b>ID</b></i></td> <td width="20%"><p align="center"><i><b>Project name</b></i></td> </tr> <% @resource.projects.each do |project| %> <tr> <td><%= link_to project.id, :action => "show", :id => projects.id %></td> <td><%= project.name %></td> </tr> <% end %> </table>
NOTE: of course i hope you have set up the correct associations in the models, which are nessessary for the controller stuff:
class Resource < ActiveRecord::Base has_many :projects end
class Project < ActiveRecord::Base belongs_to :resource end
Thorsten, Thank you for your response.That is really appreciated. I've done changes stated by you,
#Controller def proj @resource =Resource.find(params[:id], :include => :projects) end
#proj.rhtml <h1>Projects of Resource: <%= @resource.name %></h1> <table border="1"> <tr> <td width="30%"><p align="center"><i><b>ID</b></i></td> <td width="20%"><p align="center"><i><b>Project name</b></i></td> </tr> <% @resource.projects.each do |project| %> <tr> <td><%= link_to project.id, :action => "show", :id => projects.id %></td> <td><%= project.name %></td> </tr> <% end %> </table>
NOTE: of course i hope you have set up the correct associations in the models, which are nessessary for the controller stuff:
class Resource < ActiveRecord::Base has_many :projects end
class Project < ActiveRecord::Base belongs_to :resource end
for Projects of Resource: <%= @resource.name %>, it is taking correct name from database. But at <% @resource.projects.each do |project| %> it is showing error as "undefined local variable or method `projects' for #<#<Class........." I am unable to sort out it, please help me out. Thanks
well that error is most likely the result of a missing association. Have you set up the has_many :projects association as explained in my previous post? without that, the .projects method of the resource instance won't be available and result in this error.
yes you have to create an association fort this, just like with the porjects table/model
and then in your controller you can do:
@resource =Resources.find(params[:id], :include => [:projects, :trainings])
this will include the associated projects and trainings as well.
an you can use in your view :
@resource.trainings.each do |training|
blbla
end
just like with projects.
