Orderific: Because SQL is hard (and stupid)

Documentation

You can read Orderific's RDoc documentation online now.

I use Evan Weaver's "modern pretty RDoc template" Alison.

Installation

svn checkout svn://rubyforge.org/var/svn/orderific Additionally, you can install Orderific using the Rails plugin script by running from your Rails project directory: ruby script/plugin install svn://rubyforge.org/var/svn/orderific Install Subversion (I compile from MacPorts)

Example

@titles = Title.paginate(
  :conditions => ['titles.name LIKE ?', "%#{params[:query]}%"],
  :include => :publisher,
  :order => Orderific.new([['titles.name',
    { :ignore => :prefixes }], 'titles.volume']),
    :page => params[:page])

Credits