Notes 15 - Hierarchical Queries

In this tutorial you will learn how to setup and query hierarchical data structures in ]po[. You will find very few real-world reports or SQL queries in ]project-open[ that will not use hierarchical structures.

Includelet iXiam

Recording and post-processing by iXiam - your gateway to offshored media services

Contents 

In this tutorial you will learn how to setup and query hierarchical data structures in ]po[ including:

• Projects and sub-projects,
• Menus and sub-menus,
  
• Cost centers, profit centers and departments,
  
• Forum discussions and their replies,
• Configuration items and sub-items,
  
• OpenACS sitemap and the
  
• OpenACS is-part-of relationship from packages down to the objects contained by them.