Hi Tjaart, Have you tried with : #foreach($item in $results) $item.getObject('Contacts.ContactClass') $item.display('firstname') | $item.display('lastname') | $item.display('phone1') <br /> #end or #foreach($item in $results) $item.getObject('Contacts.ContactClass') $item.firstname | $item.lastname | $item.phone1 <br /> #end ? Hope this helps, Guillaume

Hi Tjaart, all, Tjaart van Wijck wrote: I think we are missing some important point about how objects are retrieved. See this FAQ... http://tinyurl.com/6rgm8h I am not able yet to relate this with Guillaume proposal. He doesn't use .getProperty and I don't know why. And this thread in xwiki-devs... http://tinyurl.com/6j5a2m I will keep this post when I get a simple example. Your feedback will be really welcome! Cheers, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

Guillaume Lerouge wrote: Thanks! -- Ricardo Rodríguez Your EPEC Network ICT Team

Hi Tjaart, Here we go at last : #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')) $itemdoc.display('firstname') | $itemdoc.display('lastname') | $itemdoc.display('phone1') <br /> #end Hopefully this will work... Guillaume

On Tue, 2008-04-15 at 14:43 +0100, Tjaart van Wijck wrote: 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

Hi Tjaart, Unfortunately removing the select part does not help and I get the same Most people simply copy/paste the standard query and it works fine for them ;-) #set ($query = ", BaseObject as obj where obj.name=doc.fullName and obj.className='Contacts.ContactClass' and obj.name<>'Contacts.ContactClassTemplate' order by doc.date desc") #set($results=$xwiki.searchDocuments($query, 10, 1)) #foreach($item in $results) #set ($itemdoc = $xwiki.getDocument($item)) #set ($itemobject = $itemdoc.getObject('Contacts.ContactClass')) $itemdoc.display('firstname') | $itemdoc.display('lastname') | $itemdoc.display('phone1') <br /> #end Guillaume

Hi all! Tjaart van Wijck wrote: It logically worked for me as well :-) Thanks! I could understand that the first part of the sentence is hardcoded for this unprivileged method as Marco said, and obj.name<>'Contacts.ContactClassTemplate' avoids that a object with all properties empty, the template, is retrieved. But, please, why obj.name=doc.fullName is required? If I remove this conditions, the query retrieve only a couple of documents with the defined properties populated and a bunch of empty ones. Sorry, I am new to HSQL!!! Thanks for any insight! Cheers, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

[Ricardo Rodriguez] Your EPEC Network ICT Team wrote: Still another entry. Sorry, I forgot it in my previous message: http://www.xwiki.org/xwiki/bin/view/FAQ/HowdoIretrievepropertiesfroma Cheers, Ricardo -- Ricardo Rodríguez Your EPEC Network ICT Team

Tjaart van Wijck wrote: $xwiki.selectDocuments is a "safe" method, because it allows to select only document names. $xwiki.search is a "privileged" method, because it allows a user to retrieve ANYTHING from the database, even data he might not have access to, like private documents or user emails or passwords (fortunately the passwords are not stored in plaintext in the database, so that is not an issue, but simple passwords could be cracked using brute force dictionary attacks). For this reason $xwiki.search requires programming rights, and is not the recommended method for retrieving information. This is why your query does not work: $xwiki.search("select obj from BaseObject obj...") will return what you told it to select: instances of BaseObject, which is the privileged com.xpn.xwiki.objects.BaseObject class, privileged as in "it should not be exposed to the scripting world". However, since you're already using a privileged method to retrieve them, that is not a problem by itself anymore. But these objects have different methods than the object API which is regularly used in velocity scripts, located in com.xpn.xwiki.api.Object, so $item.get does not work because it is not a method of that object. When you see that a method that is supposed to work doesn't, like was the case with your $item.get, then either the object is null, or has a different type than you expect it to be. What you should do in this case is try to see what's wrong, and you do this by writing: $item $item.class This will print either $item, if it is null, or something for $item followed by the real class name. You then go to that class documentation and see what you should use. So a working script would be: #set($query="select obj from BaseObject obj where obj.className='Contacts.ContactClass'") #set($results=$xwiki.search($query, 10, 1)) #foreach ($item in $results) #set($item = $item.newObjectApi($item, $context.context)) $item.get("firstname") | $item.get("surname") | $item.get("phone1") <br /> #end or: #set($query="select obj from BaseObject obj where obj.className='Contacts.ContactClass'") #set($results=$xwiki.search($query, 10, 1)) #foreach ($item in $results) $item.displayView("firstname", $context.context) | $item.displayView("surname", $context.context) | $item.displayView("phone1", $context.context) <br /> #end Either one of these is NOT recommended, as they require programming rights. The proper way is: #set($query=", BaseObject obj where obj.name = doc.fullName and obj.className='Contacts.ContactClass' and obj.name <> 'Contacts.ContactClassTemplate'") ## Replace with the real name of your template document, if there is one #set($results=$xwiki.searchDocuments($query, 10, 1)) #foreach ($docName in $results) #set($docItem = $xwiki.getDocument($docName)) #foreach($item in $docItem.getObjects("Contacts.ContactClass)) $docItem.display("firstname", $item) | $docItem.display("surname", $item) | $docItem.display("phone1", $item) <br /> #end #end This is different from the other suggested scripts because it does not assume that there is only one object in each document, but it iterates over each object of that type. -- Sergiu Dumitriu http://purl.org/net/sergiu/

Thanks, these are extremely helpful comments. On 21/04/2008, Sergiu Dumitriu &lt;sergiu(a)xwiki.com&gt; wrote: