Ancestry and pg_search and order scope

[phlegx]

Hi!

Any idea how to use ancestry and pg_search (https://github.com/Casecommons/pg_search)? I want to search on all parents.

# app/models/zone.rb

class Zone < ActiveRecord::Base
  include PgSearch
  pg_search_scope :search,
      against: :name, associated_against: {
          parent: :name,
      }
...

Search using Zone.all.search('My By Parent Name')

Another question: is it possible to order all zones by its parents name?

# app/models/zone.rb

class Zone < ActiveRecord::Base
...
    scope :order, -> { order('parents.name ASC') }
...

[vanderhoorn]

I'm not sure how pg_search works and/or combines with ancestry. But do note that ancestry's parent_id is not an Active Record column, but a method. Ancestry only uses (by default) the ancestry column.

[phlegx]

@vanderhoorn ok thank you. But how can I order all Zones by its parent name?

[kbrock]

I would like to introduce parent_id as a scope or actual sql. Will look into this but to be honest, probably won't happen any time soon