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.
_______________________________________________
users mailing list
users@xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
