Hi all. Let's say that quizzes have many tags, through taggings. I'm doing a search on quizzes, including various other associations, and passing in various conditions, such as "quizzes.name like '%english%'" or "quizzes.subject = 'Language'".
If i'm given a parameter :tag => "banana" then i want to order my results so that the quizzes are ordered by their tags, but with the ones with the 'banana' tag pushed up to the top of the results. I'm doing a paginated search (with will_paginate) so i don't want to get all of the results with a regular find(:all) and then re-order them - i want to do it in the sql Can i do this by passing something to the 'order' option? Something along these pseudo-code lines (the order option is not valid but hopefully gets my requirement across): @quizzes = Quiz.paginate(:all, :conditions => <conditions>, :order => "tags.name = 'banana' or tags.name", :page => params[:page], :per_page => 25) grateful for any advice - thanks, max -- Posted via http://www.ruby-forum.com/. -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" 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/rubyonrails-talk?hl=en.
