ActiveRecord Where query with parent attribute?

[zw963]

milk = Category.find_by(name: 'milk')

Category.create(name: 'acid milk', parent: milk)   # => this worked for me

Category.where(name: 'acid milk', parent: milk)  # => this not worked, not implement yet ??
# PG::UndefinedColumn: ERROR:  column categories.parent does not exist

[zw963]

Have a more quickly method to do this? (add a field ??)

What I does is:

Category.where(name: 'acid milk').find {|x| x.parent == milk }

[vanderhoorn]

Ancestry only uses the ancestry column. i.e. parent_id is not an ActiveRecord column. Instead, parent and parent_id are methods, so you cannot use parent in a where-clause.

What about:

milk = Category.find_by(name: 'milk')

milk.children.where(name: 'acid milk')

[zw963]

Thanks, your's answer more efficient than me in my case.