[xwiki-users] Tag search returns no results

Hi community, I have a problem with the page Main.Tags – the tags are displayed in the page, but there are no results in the search table (on click on the certain tag) I.e. the query #set($sql = "select distinct elements(prop.list) from BaseObject as obj, DBStringListProperty as prop where obj.className='XWiki.TagClass' and obj.id=prop.id.id and prop.id.name='tags'") #set ($tags = $xwiki.search($sql)) works, but the next query on the same page #set($sql = ", BaseObject as obj, DBStringListProperty as prop where obj.name=doc.fullName and obj.className='XWiki.TagClass' and obj.id=prop.id.id and prop.id.name='tags' and '$request.tag' in elements(prop.list) order by doc.name asc") #set ($list = $xwiki.searchDocuments($sql)) returns no results ($list.size()=0) xwiki.log and catalina.out don’t show any error. Our environment: - XE 1.5 - Tomcat 6.0.16 - JDK 1.6 Update 7 - MySQL Community Server 5.0.51a - MySQL Java Connector 5.0.8 I’m not sure I’m right, but it looks like subselect * '$request.tag' in elements(prop.list) * doesn’t work properly (if I cut it off, I get some results), although subqueries should be supported in MySQL 5. In our other application (Environment XE 1.2 + OC4J + Oracle 10g) the same tag search works absolutely fine. How can I work around to get tagged documents? Thanks in advance, Alla -- View this message in context: http://n2.nabble.com/Tag-search-returns-no-results-tp786999p786999.html Sent from the XWiki- Users mailing list archive at Nabble.com.