> Wha I need to obtain is somewhat like a "left join": I get a List of
> ClusterNodes that have the desired fields of each type1 instance and (if
> exist) their corresponding values in type2, getting NULL for that fields if
> no type2 record is related to that type1 instance.
Hi,
in the webpages usually we use 2 related nodes in eachother if we want this
behaviour.
<mm:node>
<mm:relatednodes type="a">
<mm:relatednodes type="b">
</mm:relatednodes>
</mm:relatednodes>
</mm:node>
the problem with this is that you can get a uge amount of queries (N*)
Michiel wrote some code that makes it possible to get the data for the above
querie in 3 queries. I haven't looked a the code so I can't tell you exactely
how it works. it's called TreeList and GrowingTreeList cat be found in
org.mmbase.birdge.util.
hope this helps