I think I have search working by doing this: @location_products = @location.location_products unless ! params[:search].nil? @location_products = @location.location_products.find(:all, :conditions => "product_id in (select id from products where name like '%" + params[:search] + "%')") unless params[:search].nil?
Working on sort now... On Feb 8, 4:21 pm, Brian Corbin <[email protected]> wrote: > My apologies for yet another thread on table-plus, but I didn't see > the answer for this particular problem. I'm trying to enable sorting > and searching for a table-plus tag on the show controller of my > Location model. The goal is to be able to view the Products stored at > a Location > > In locations\show.dryml: > <table-plus with="&@location_products" fields="product.name, > product.code, current, minimum, restock_to"> > > In controllers\locations_controller.rb: > def show > �...@location = find_instance > �...@location_products = > �[email protected]_products.apply_scopes(:search => > [params[:search], ???What goes here??? ], > :order_by => parse_sort_param(??? > What goes here???, :current, :minimum, :restock_to)) > > end > > So the question is how do I allow searching and sorting on > product.name and/or product.code? > > Here are the relationships (pseudo-code): > Location has_many :products, :through => :location_products, > has_many :location_products > Product has_many :location_products, has_many :locations, :through > => :location_products, :accessible => true > location_products belongs_to :location, belongs_to :product > > Thanks in advance! -- You received this message because you are subscribed to the Google Groups "Hobo Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/hobousers?hl=en.
