[Ricardo Rodriguez] eBioTIC. wrote:
Hi!
I'm trying to understand the Query Guide available at http://xpescaderias.environmentalchange.net/xwiki/bin/view/Species/SpeciesCl... but still failing to get an answer to a problem.
I navigate to a document with this query...
#set($species = $doc.getObject('Species.SpeciesClass').getProperty('GalicianName').getValue())
#set($query = ", BaseObject as obj, LargeStringProperty as prop where doc.fullName = obj.name and obj.className='Users.PdrUserClass' and obj.id=prop.id.id and prop.id.name='Species' and prop.value like '" + $species + "' order by doc.fullName asc")
That should do it. Note: For better security the query should be: #set($query = ", BaseObject as obj, LargeStringProperty as prop where doc.fullName = obj.name and obj.className='Users.PdrUserClass' and obj.id=prop.id.id and prop.id.name='Species' and prop.value like ? order by doc.fullName asc") then #set($results = $xwiki.searchDocuments($query, [$species]) This makes sure $species is escaped preventing sql injection. Caleb
I would like to set the value of $species to the value of the property GalicianName of the class Species.SpeciesClass instantiated in this document.
Please, could anybody help me to solve this doubt? Thanks!
Ricardo