2 Replies Latest reply on Jun 6, 2013 3:35 AM by Amit Jain

    Rhom Order by Issue

      Hi ,

       

      while i am implementing order by it is sorting element first for upper case and then lower case i want to ignore the case while sorting

       

      @departments =  Departments.find(:all,:conditions => { {:name => "usertypeid" } => Common::GetUserType(),

            {

            :name => 'allowedoperations',

            :op => 'LIKE'

            } => "%Add%"

          }, :order => 'department',:orderdir => 'ASC' )

       

      Please help to ignore the case.