If you're searching LargeStringProperties, just replace #set($query = ", BaseObject as obj, StringProperty as prop where ... with #set($query = ", BaseObject as obj, LargeStringProperty as prop where ... Caleb [Ricardo Rodriguez] eBioTIC. wrote:

Hi!

Caleb and I have been chatting this afternoon about a solution to pass the value of a variable to a query string. Thanks Caleb!

Something like this...

##$species is defined simply by...

#set($species = '%babo%')

##and the query string is constructed by using + to concatenate stubs including the value of that variable...

#set($query = ", BaseObject as obj, StringProperty 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")

This works great with com.xpn.xwiki.objects.StringProperty properties, but not with com.xpn.xwiki.objects.StringProperty ones.

Please, do you know why and what is required to filter by properties of that type? Thanks!

Ricardo