Hi,
here I have a problem with a xwiki 1.0 which upgraded from an existing
xwiki 0.9.840 which someone named a page like: "Jon's Pages" conflict
with the navagation panel's sql statement.
I did a velocity script but I don't find it support "[ ]" wildcard noted
in this reference manual:
http://manuals.sybase.com:80/onlinebooks/group-as/asg1250e/refman/%40ebt-li…
since I just want to select where name not like mywhitelisted
characters.
the blacklisted characters should be those used by xwiki syntax, and
those symbol used in sql statement like "'" """
any one know how to use the wildcard to done that?
or any other solutions?
Thx in advance!
I already have this:
#set ($query = "where doc.name like '%--%'")
{table}
Page Name | Author | date
#foreach ($item in $xwiki.searchDocuments("${query}"))
##if ($xwiki.hasAccessLevel("view", $context.user,
"${context.database}:${item}"))
#set($bentrydoc = $xwiki.getDocument($item))
[${bentrydoc.web}.$bentrydoc.name] |
$xwiki.getLocalUserName($bentrydoc.author) |
$xwiki.formatDate($bentrydoc.date, $dateFormat)
##end
#end
{table}
Muzi