Jean Couteau wrote:
> 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'
To better understand these queries, you should look at the hibernate
mapping files and the HQL documentation.
http://svn.xwiki.org/svnroot/xwiki/platform/core/trunk/xwiki-core/src/main/resources/xwiki.hbm.xml
http://www.hibernate.org/hib_docs/reference/en/html/queryhql.html
We're lacking documentation on this, and queries using HQL are pretty
much developer oriented. We're working on alternative querying models
which are already available, but not ready for general use yet.
> 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
>>
>
>
--
Sergiu Dumitriu
http://purl.org/net/sergiu/
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users
