Re: [xwiki-users] AllAttachments live table doesn't show anything

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-tp4875… Sent from the XWiki- Users mailing list archive at Nabble.com.