Creating navigation hierachies using queryies

[bruno@…]

[jira2trac import : issue created on March 2, 2006 9:33:47 AM CET ​http://issues.cocoondev.org/browse/DSY-248 ]

A query in a navigation tree only allows to generate a flat list of nodes. It would be useful if we could create hierarchical structures using a query. Thus, dynamically creating group nodes.

Currently, the first value selected in a query becomes the node label. We could add the convention to this that any other selected values are used to group on.

For example, take the following query:

select name, $Category, $Type where blah blah order by $Category, $Type

This would first create group nodes per value of the $Category field, and inside that, groups per $Type field.

[paul]

[jira2trac import : comment created by bruno on April 5, 2006 9:04:58 AM CEST]

Implemented, though slightly different: the grouping is more logically done from left to right (which also makes it possible to sort on the leave-node), thus the query from the description would be written as:

select $Category, $Type, name where blah blah order by $Category, $Type

Still todo: docs.