Hi All,
I am having an issue with an error when running a velocity macro in xwiki.
Within the Oracle database I have a table containing a list of page names. I
am trying to run a script where the system takes this list, cycles through all
pages within a space and deletes any pages who's name appears on the list.
Here's what I have so far...
....
#set($sql = " where doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data
FROM lovtestdata)")
#DeletePagesLocal($sql)
....
#macro(DeletePagesLocal $sql)
#foreach($item in $xwiki.searchDocuments($sql))
#set($itemdoc = $xwiki.getDocument($item))
$itemdoc.delete()
#end
#end
The error I am getting is:
Caused by: com.xpn.xwiki.XWikiException: Error number 3223 in 3: Exception
while searching documents with SQL [select distinct doc.space, doc.name from
XWikiDocument as doc where (doc.hidden <> true or doc.hidden is null) and
doc.space='AlarmIdentifiers' AND doc.name IN (SELECT data FROM lovtestdata)]
Wrapped Exception: lovtestdata is not mapped [select distinct doc.space,
doc.name from com.xpn.xwiki.doc.XWikiDocument as doc where (doc.hidden <> true
or doc.hidden is null) and doc.space='AlarmIdentifiers' AND doc.name IN (SELECT
data FROM lovtestdata)]
Essentially it is saying that the table is not mapped.
If anyone could point me in the right direction it would be great.
Many thanks
Luke
LEGAL NOTICE
This email and any files transmitted with it are confidential, may be
privileged and are intended solely for the use of the individual or entity to
whom they are addressed. If you are not the intended recipient, please
telephone or email the sender on +44 (0) 1785 827 000 and delete this message
and any attachment from your system; you must not copy or disclose the contents
of this message or any attachment to any other person.
Any views or opinions presented are solely those of the sender and do not
necessarily represent those of Capula Limited and we accept no liability for
its accuracy or completeness. Copyright in this email and any attachment
created by us belongs to Capula Limited.
Please ensure you have adequate virus protection before you open or detach any
documents from this transmission. Capula Limited does not accept any liability
for any loss or damage arising in any way from the receipt or use thereof. Any
e-mail reply to this address may be subject to monitoring for operational
reasons or lawful business practices.
Capula Limited
Registered No 00953504 England
Registered Office Orion House, Stone, Staffordshire, ST15 0LT.
_______________________________________________
users mailing list
[email protected]
http://lists.xwiki.org/mailman/listinfo/users
