Marco, Unfortunately removing the select part does not help and I get the same error.
It is hard to believe that few people have managed to construct a query for all object of the same class. I though this would be straight forward. I want to retrieve a list of object from a specified class and then print all their attributes. Kind regards, -Tjaart On 15/04/2008, Marco Fabbri <[EMAIL PROTECTED]> wrote: > > On Tue, 2008-04-15 at 14:43 +0100, Tjaart van Wijck wrote: > > > > #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 > > > >From the reported exception message the error seems to lay in the HQL > query. When using the "unprivileged" searchDocument API method you have > the beginning of the query already set up so the "select obj from > BaseObject obj" happens to be inserted in the query after another select > (you should start $query with the where clause), causing the reported > error. > > Have a look at > > <http://platform.xwiki.org/xwiki/bin/view/DevGuide/velocityHqlExamples#HPublicAPI28searchDocuments29> > for further info. > > -- > Marco > > ===== > "We know nothing > — that is the first point. > Therefore we should be very modest > — that is the second. > That we should not claim to know when we do not know > — that is the third." > > Karl R. Popper > > > _______________________________________________ > users mailing list > users@xwiki.org > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users