Re: [xwiki-users] Search on StringListProperty

I see the Blog code has an example to search on a DBStringListProperty, but I have a static list, which I believe is a StringListProperty. If I try to use the following SQL: #set ($sql = ", BaseObject as obj, StringListProperty as prop join prop.list list where obj.name=doc.fullName and obj.className='ReleaseInfo.BuildStatus' and obj.id=prop.id.id and prop.id.name='recommended' and list='Distributed' order by doc.creationDate desc") I get the following error: Wrapped Exception: could not resolve property: list of: com.xpn.xwiki.objects.StringListProperty select distinct doc.web, doc.name, doc.creationDate from com.xpn.xwiki.doc.XWikiDocument as doc , com.xpn.xwiki.objects.BaseObject as obj, com.xpn.xwiki.objects.StringListProperty as prop join prop.list list where obj.name=doc.fullName and obj.className='ReleaseInfo.BuildStatus' and obj.id=prop.id.id and prop.id.name='recommended' and list='Distributed' order by doc.creationDate desc? It seems like it should work ok, so I don't know why I'm getting that error. If I simply change StringListProperty to DBStringListProperty I don't get an error, but also I don't get any results. I can change to using a DBStringListProperty if that's the only way to do it, but I'd like to keep it as it is if at all possible. Thanks ... shawn. ------------------------------------------------------------------------ -- You receive this message as a subscriber of the xwiki-users(a)objectweb.org mailing list. To unsubscribe: mailto:xwiki-users-unsubscribe@objectweb.org For general help: mailto:sympa@objectweb.org?subject=help ObjectWeb mailing lists service home page: http://www.objectweb.org/wws