Administrate: How to sort by relationship field

Created on 30 Nov 2015 · 8Comments · Source: thoughtbot/administrate

Hi all!

I searched through documentation and code and didn't find a way to sort the records by a relation field.

This is related to #265.

There is someone working on it? If not, I'd be happy to provide PR.

bug sorting

Source

Rodrigora

👍4

Most helpful comment

Does anyone have any updates on this type of thing? Being able to sort/search by an attribute on a belongs_to association would be a huge win for me.

hughfm on 6 May 2016

👍8

All 8 comments

Hey, @Rodrigora! Thanks for the suggestion!

Right now this isn't supported. I'm a bit curious about how you'd sort by a relationship - it seems like it would vary depending on whether the relation is a has_many, belongs_to, has_one, or polymorphic relationship.

Can you elaborate on what behavior you'd like to see?

gracewashere on 1 Dec 2015

My models are:

class Product
  belongs_to :category
end

class Category
  has_many :product
end

I'd like to sort products by category name, since my products page has the columns id and category (Category column displays the category name).

Rodrigora on 1 Dec 2015

I've used this before with spree:
https://github.com/activerecord-hackery/ransack

Could be an easy win.

sebbean on 1 Dec 2015

I've just implemented a very hacky version. This class sits at the bottom of the user controller.
I'm not suggesting it as a fix but might help in your case :)

class SearchUser
  def initialize(resolver, term)
    @resolver = resolver
    @term = term
  end

  SEARCH_TABLES = %w(addresses vouchers)
  # Manually add the joins for these tables

  def run
    if @term.blank?
      resource_class.all
    else
      resource_class.uniq
        .joins(:addresses, user_vouchers: [:voucher])
        .where(query, *search_terms)
    end
  end

  private

  delegate to: :resolver

  def query
    prefixed_attributes.map { |attr| "lower(#{attr}) LIKE ?" }.join(' OR ')
  end

  def search_terms
    ["%#{term.downcase}%"] * prefixed_attributes.count
  end

  def prefixed_attributes
    [resource_class] + SEARCH_TABLES.flat_map do |table|
      attributes_for(table).map { |attr| "#{table}.#{attr}" }
    end
  end

  def attributes_for(dashboard)
    Object.const_get(dashboard.classify + 'Dashboard')::ATTRIBUTE_TYPES.select do |_, type|
      type.searchable?
    end.keys
  end

  attr_reader :resolver, :term
end