Symfony Doctrine Nested Set Path To Root Query

Question

Is there a way in symfony to get from a doctrine nested set the whole path/route from a specified by id element to the root element in a Doctrine_Collection or array ?

johnwards · Accepted Answer · 2010-05-14 15:57:49Z

2

I think this should return what you are after:

$obj->getNode()->getAncestors();

From the docs

answered May 14, 2010 at 15:57

johnwards

1,9113 gold badges18 silver badges27 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Henrik · Accepted Answer · 2010-12-15 08:51:23Z

1

If you're thinking of building something like a breadcrumb trail, getPath would do it:

getPath
public string getPath(string seperator, mixed includeRecord, bool includeNode)

gets path to node from root, uses record::toString() method to get node names

Parameters:
    seperator - path seperator
    includeNode - whether or not to include node at end of path
Returns:
    string representation of path

http://www.doctrine-project.org/api/orm/1.2/doctrine/doctrine_node_nestedset.html#getPath%28%29

So you need to override __toString() in your model. If you don't, Doctrine will try to guess what to write by looking for columns called "name", "title" and the like.

answered Dec 15, 2010 at 8:51

Henrik

3623 silver badges11 bronze badges

Collectives™ on Stack Overflow

Symfony Doctrine Nested Set Path To Root Query

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related