按字母顺序排序ActiveRecord结果

Question

我有一个控制器方法如下:

def index
  @categories = Category.all
end

如何按字母顺序排序@categories名称？

- user4932805

Answer 1

您可以进行“订单”操作：

@categories = Category.order(:name)

- potashin

Answer 2

在你的分类控制器中：

 class CategoriesController < ApplicationController

     def index
         @categories = Category.order(:name)
     end
  end

默认情况下，这将按字母顺序对:name列进行排序。

- Cyzanfar

Answer 3

#default ascending

  class CategoriesController < ApplicationController

    def index
      @categories = Category.order(:name)
    end
  end

#explicit ascending if you were chaining a scope that has some other default order

  class CategoriesController < ApplicationController

    def index
      @categories = Category.tags.order(name: :asc)
    end
  end

#decending

 class CategoriesController < ApplicationController

   def index
     @categories = Category.tags.order(name: :desc)
   end
 end

- C dot StrifeVII