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