Re: [xwiki-users] Trouble with velocity script to list Object properties

Hi Guillaume, Thanks for the advise but it still doesn't work. I've implemented: #set($query="select obj from BaseObject obj where obj.className='Contacts.ContactClass'") #set($results=$xwiki.searchDocuments($query, 10, 1)) #foreach($item in $results) #set ($itemdoc = $xwiki.getDocument($item)) #set ($itemobject = $itemdoc.getObject('Contacts.ContactClass')) $itemobject.display('firstname') | $itemobject.display('lastname') | $itemobject.display('phone1') <br /> #end But get the error: Error number 4001 in 4: Error while parsing velocity page Contacts.Contacts Directory Wrapped Exception: Invocation of method 'searchDocuments' in class com.xpn.xwiki.api.XWiki threw exception com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception while searching documents with SQL web, doc.name from XWiki Document as doc where select obj from Base Object obj where obj.class Name='Contacts.Contact Class'? Wrapped Exception: unexpected token: select near line 1, column 85 web, doc.name from com.xpn.xwiki.doc.XWiki Document as doc where select obj from com.xpn.xwiki.objects.Base Object obj where obj.class Name='Contacts.Contact Class'? @ Contacts.Contacts Directory2,22 I also tried this with $itemdoc.display(...) as you suggested but that is not the source of the problem. Am I right in suspecting that HQL queries like "select doc from XWikiDocument..." will return a resultset of "XWikiDocuments" but a HQL query like "select obj from BaseObject..." will return a resultset of BaseObjects. I think the cause of the exception might be that seachDocuments should requires a doc resultset as parameter. Any ideas? Thanks. On 15/04/2008, Guillaume Lerouge &lt;guillaume(a)xwiki.com&gt; wrote: