I would be honored to do so, I just don't know if I have the right to post/edit other people work in there. I am sorry but I not familiar yet with the names of people in XWiki and I don't know if you are one of them. I also have no idea where to place this, just as a comment in the page you give me or there is a more specific space/page for TODO list?
On Mon, Aug 17, 2009 at 2:31 PM, Guillaume Lerouge <guilla...@xwiki.com>wrote: > 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. > > Thanks, > > Guillaume > > > > > > _______________________________________________ > > users mailing list > > firstname.lastname@example.org > > http://lists.xwiki.org/mailman/listinfo/users > > > > > > -- > Guillaume Lerouge > Product Manager - XWiki > Skype: wikibc > Twitter: glerouge > http://guillaumelerouge.com/ > _______________________________________________ > users mailing list > email@example.com > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ users mailing list firstname.lastname@example.org http://lists.xwiki.org/mailman/listinfo/users