Hierarchal data search. about scoped_search HOT 2 CLOSED

Yeah this is more of a general querying thing than a scoped_search thing ;-). I've done similar before, you can't do it directly in the gem because you can't do it directly in SQL. (NOTE: you can-ish but its super vendor specific)

So does the search just need to match any children within the tree starting from the parent? What I do in that case is I get out all the relevant node_ids first and then run a query like:

class Node < ActiveRecord::Base

  scoped_search on: :name

  def recursive_children
    children_ids = # some logic to find recursive child ids
    Node.where(id: ids)
  end
end

parent.recursive_children.search_for('foo')

Basically you make a method first that returns an AR::Relation, and then you can search that. That will work to return any node with a matching string within the tree. It won't match the case if the search needs to be applied to every level and all return true.

from scoped_search.

Thank you very much for taking the time to look into this. That's an interesting idea. I'll give it a whirl! Thanks again

from scoped_search.