[symfony-users] how to retrieve descendents's contents when i already konw it's top parent with doctrine nestedset

[aywhen]

MySchema

  Category:
     actAs: { NestedSet: ~ }
     columns:
       name: string(255)
     relations:
       Contents:
           local:id
           class: Content
           foreign: category_id
           foreignAlias: Category


  Contents:
     columns:
        title: string(255)
        content: clob
        category_id: integer

for example
category tree is
  A
  -- B
  ---C
  -------D

if B,C,D categories all have Contents, but i need retrieves contents
through it's top parent A, how to write something to get the results ?


--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to 
symfony-users+unsubscr...@googlegroups.com
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---