Michiel Meeuwissen <[EMAIL PROTECTED]> wrote .... > In 1.7 syntax that could be done nicer: > > <mm:node number="$author"> > <mm:relatednodes type="documents" role="posrel" orderby="posrel.pos" directions="UP"> > .... > </mm:relatednodes> > </mm:node> > > In order words, no need to use element="document" in these cases, which > looks nicer, and would be more efficient for the database too. > Because I often don't need all fields of a document node, I would use something like:
<mm:related path="posrel,documents" fields="document.description" orderby="posrel.pos" directions="UP"> Do you think that is more efficient in the case you need only certain fields? I am not sure about the caching of MMBase. Does it work only on nodes or does it work for any generated sql? Martijn Houtman
