I would have a look to this sql request.
#set ($sql = ", BaseObject as obj where obj.name=doc.fullName and
obj.className='${doc.space}.${class}Class' and
obj.name<>'${doc.space}.${class}ClassTemplate' and obj.space='Space
1')
I am not sure as i do not have the same configuration, but i think it
should be quite close, or maybe with obj.spaceName='Space 1'
I am quite interested in your results cause i might implement something
similar in the future.
Hope this helps.
Kevin_C a écrit :
OK, that makes sense.. In fact I think I saw something
similar in the ToDo
tutorial, I should have remembered that. Do you know how I would go about
querying for the 5 most recently created documents of a given type within a
space?
What I'm trying to accomplish is something like:
FAQs
Space 1
* Doc 1
* Doc 2
* Doc 3
* Doc 4
* Doc 5
Space 2
* Doc 1
* Doc 2
* Doc 3
* Doc 4
* Doc 5
and so on...
I know you can query for docs of a specific type but what about narrowing
the search to a space?
Thanks!
.:. Kevin
--
----
Jean Couteau
Code Lutin -
http://www.codelutin.com
44 Bd des Pas Enchantés - 44230 St-Sébastien/Loire
Tél : 02 40 50 29 28 - Fax : 09 59 92 29 28