Hi,
we had the same issue with the view “AllAttachments” from the Main.AllDocs.
Environment – Oracle 10.2, JDK 1.6, Tomcat.6.0 (used also OC4J).
Tested on XE 2.1.2 – 2.1.5. All necessary pages are saved with programming
rights.
All tabs (views) worked fine but the livetable in the “Attachments”- tab was
empty. The table in “Deleted attachments”-view was filled,
in the Tree-tab (treeview) all attachments were available as well.
Environment – Oracle 10.2, JDK 1.6, Tomcat.6.0 (used also OC4J).
Tested on XE 2.1.2 – 2.1.5
I think, I found it.
Simple query in XWiki.AllAttachmentsResults
#set($sql = "select doc.fullName, attach from XWikiDocument as doc,
XWikiAttachment as attach where attach.docId=doc.id")
$xwiki.search($sql)
- works fine
The problem is in the clause
#if($title)
#set($title = $title.trim().toLowerCase())
#set($sql = "and lower(doc.fullName) like '%${title}%' ")
#else #set($sql = "and lower(doc.fullName) <> '' ") #end,
(two single quotes after <>, i.e. "empty string"), that generates the next
sql statement:
select doc.fullName, attach from XWikiDocument as doc, XWikiAttachment as
attach where attach.docId=doc.id and lower(doc.fullName) <> '' order by
attach.filename asc
This query returns 0 rows (at least against the Oracle DB) – perhaps of
well-known Oracle specific issue to treat an empty string as NULL and the
right comparison for Oracle would be smth like "doc.fullName in not NULL" or
"length(doc.fullName) > 0" - tested both of them - work OK, the both return
the list of attachments.
And if I just use instead of empty string '' blank ' ' or use as escape
characters one more set of single quotes (''''), the problem is solved as
well - the livetable is filled with all wiki attachments.
Best Regards,
Alla
-----
Best Regards,
Alla
--
View this message in context:
http://n2.nabble.com/AllAttachments-live-table-doesn-t-show-anything-tp4875907p4931164.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
