如何按id对ActiveAdmin CSV表进行排序？

ActiveAdmin.register YourModel do
  controller do
    def index
      super do |format|
        format.csv do
          csv_options = { col_sep: ',' }
          headers['Content-Disposition'] = "attachment; filename=\"your_models.csv\""
          headers['Content-Type'] ||= 'text/csv'
          
          # 定义CSV列和排序
          csv_data = CSV.generate(csv_options) do |csv|
            csv << ['ID', '名称', '其他列']
            collection.order('id ASC').each do |item|
              csv << [item.id, item.name, item.other_column]
            end
          end

          # 输出CSV数据
          self.response_body = csv_data
        end
      end
    end
  end
end