Hi Nikos,

On Mon, Aug 17, 2009 at 1:58 PM, Nikos Georgosopoulos <georg...@gmail.com>wrote:

> Hi all,
> I have been trying for the last day to put the TODO app in my wiki and it
> kept on failing to show the mytodo list in the panel. I use Oracle for
> backend so I thought it was that the problem. Here is the panel's code
> corrected to work in my case (XWiki 1.9.3, Tomacat 6, Oracle XE 11):
> #panelheader('My Todos')
> #set ($hql = ", BaseObject as obj, StringProperty as prop1,
> LargeStringProperty as prop2 where obj.name=doc.fullName and
> obj.className='XWiki.TodoClass' and obj.name <> 'XWiki.TodoClassTemplate'
> and obj.id=prop1.id.id and prop1.id.name='Status'
> and prop1.value <> 'Finished' and obj.id=prop2.id.id
> and prop2.id.name ='Assignee' and prop2.value like '$context.user'
>  order by doc.date desc")
> #foreach ($todo in $xwiki.searchDocuments($hql, 5, 0))
> * [$todo]
> #end
> #panelfooter()
> The big difference is the LargeStringProperty (Instead of StringProperty
> used in the XAR) and the like instead of = used to match the value.
> For the LargeStringProperty it is strange for me that someone chose a CLOB
> to store user names but... maybe because of the class hierarchy involved in
> the user name. Then again, how can this work even without oracle?
> For the like, well, oracle atleast will not even bother checking a string
> against a stream. Yes the words are phonetically close but.... oracle
> doesn't care about phonetics.
> I hope others out there will enjoy this helpful app.

Glad you liked it :-)

It would be cool if you updated the page on code.xwiki.org explaining how
you made the app work under Oracle.



> _______________________________________________
> users mailing list
> users@xwiki.org
> http://lists.xwiki.org/mailman/listinfo/users

Guillaume Lerouge
Product Manager - XWiki
Skype: wikibc
Twitter: glerouge
users mailing list

Reply via email to