Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Sort a table_for in rails activeadmin

In an active admin show page, I've got two panels, the first being the primary record, the second being associated info (by has_many) so show looks like this:

panel "Max Amount" do
  table_for user.max_amount do
    column 'Amount', :amount
    column 'time', :updated_at
  end
end

Can i sort this high-to-low (or low-to-high) on the amount column?

Update: I found the source for the demo ( https://github.com/gregbell/demo.activeadmin.info/blob/master/app/admin/users.rb ) which seems to have sorting but when you go to the actual demo site it's not working. Is this feature perhaps broken? Is there a work-around?

like image 688
Will Avatar asked May 15 '12 20:05

Will


2 Answers

The only way I found to do it was a bit hacky. ActiveAdmin will pass in the column name and asc/desc via the params hash, then you can add that to your query.

Also, make sure to pass "sortable: true" into the table_for call.

panel "P&L" do
  table_for Quote.order(params[:order].gsub('_', ' ')), sortable: true do
    column("Revenue", sortable: :revenue) { |quote| number_to_currency quote.revenue }
    column("Profit", sortable: :profit)  { |quote| number_to_currency quote.profit  }
  end
end
like image 149
idrinkpabst Avatar answered Sep 20 '22 06:09

idrinkpabst


With rails 4.2, based on @idrinkpabst, I did the following:

table_for group.devices.order(
  # Support for column name with underscore
  # Support "no sort param"
  (params[:order] ? params[:order] : '').gsub('_asc', ' asc').gsub('_desc', ' desc')
), sortable: true do
  # Directly using symboles and not using sortable:
  column :presence
  column :serial_number
  column :apk_version
  column :firmware_version
end

It's a more robust version:

  • allows column name with underscore
  • support "no sort param"
  • works with rails 4.2
like image 36
Gab Avatar answered Sep 22 '22 06:09

Gab