29 Sep
2010
29 Sep
'10
5:47 p.m.
[Ricardo Rodriguez] eBioTIC. wrote:
Hi!
I'm trying to understand the Query Guide available at
http://xpescaderias.environmentalchange.net/xwiki/bin/view/Species/SpeciesC…
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