Hi Nikos, On Mon, Aug 17, 2009 at 1:58 PM, Nikos Georgosopoulos <georgosn(a)gmail.com 'XWiki.TodoClassTemplate' CLOB in 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 -- Guillaume Lerouge Product Manager - XWiki Skype: wikibc Twitter: glerouge http://guillaumelerouge.com/ _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

Hi Nikos, On Mon, Aug 17, 2009 at 4:30 PM, Nikos Georgosopoulos <georgosn(a)gmail.com It's a wiki, feel free to edit and add information to it as long as you do so in good faith and bring relevant information :-)

I'm definitely one of "them" - as every member of this community is. I simply happen to be posting a bit more often than most other people around here ;-) hmmm, where do you find the time? someone pays you to do that? can they pay

me Well, if your code works for all databases the best thing to do would be to update the application's XAR on the website. To do so you would need to export the application from your wiki and replace the current one with yours.

You can use http://code.xwiki.org/xwiki/bin/view/Applications/ImportExportApplicationto export the updated TODO application from your current wiki. You'll need to include all the pages from the original XAR file. You can then upload it here: http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplicationDownloads#… you've made sure it works fine (by installing it on a local wiki for instance).

Please let me know if you need additional help. Looking forward your first contribution, Guillaume and for code -- Guillaume Lerouge Product Manager - XWiki Skype: wikibc Twitter: glerouge http://guillaumelerouge.com/ _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

Well, as I was waiting for your reply, I posted it to my blog, is it in good faith if I make a link from the page of the app to it? http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplication?

On Mon, Aug 17, 2009 at 4:44 PM, Guillaume Lerouge <guillaume(a)xwiki.com georgosn(a)gmail.com > > > > 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. > > > It's a wiki, feel free to edit and add information to it as long as you do Thanks for clarifying this, it is formed as a wiki but it could have access rights reserved (XWiki gives the option). around pay others too?

give to I have not tested all databases, there is the possibility that the two changes I made have to be like this only for Oracle since not so many Databases use CLOBS for larg strings (other use text) http://code.xwiki.org/xwiki/bin/view/Applications/ImportExportApplicationto to http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplicationDownloads#… Well, I am intrigued, I will try to find some time to test around and see but it will be a slow process. In the meantime, others could try it, isn't there anyone else using TODO list app?

guillaume(a)xwiki.com 11): a oracle _______________________________________________ users mailing list users(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users

Guillaume Lerouge wrote: By the way, Guillaume himself is not a committer.

I find this absolutely reasonable justification. I will create a page then and put it there. Then I will link the TODOs page with the new one. How does that sound?

On Mon, Aug 17, 2009 at 5:14 PM, Vincent Massol &lt;vincent(a)massol.net&gt; wrote: > > On Aug 17, 2009, at 4:59 PM, Nikos Georgosopoulos wrote: > >> Well, as I was waiting for your reply, I posted it to my blog, is it >> in good >> faith if I make a link from the page of the app to it? >> http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplication? > > Well it's easier if people can find all the information they need on > the xwiki.org wiki. Also if your blog disappears for any reason (you > switch blogs, etc) then the link will be broken. > > Thanks > -Vincent > >> On Mon, Aug 17, 2009 at 4:44 PM, Guillaume Lerouge &lt;guillaume(a)xwiki.com >>> wrote: >> >>> Hi Nikos, >>> >>> On Mon, Aug 17, 2009 at 4:30 PM, Nikos Georgosopoulos < > georgosn(a)gmail.com >>>> wrote: >>> >>>> 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. >>> >>> >>> It's a wiki, feel free to edit and add information to it as long as >>> you do >>> so in good faith and bring relevant information :-) >>> >> >> Thanks for clarifying this, it is formed as a wiki but it could have >> access >> rights reserved (XWiki gives the option). >> >> >>> >>> >>>> 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'm definitely one of "them" - as every member of this community >>> is. I >>> simply happen to be posting a bit more often than most other people >>> around >>> here ;-) >>> >>> hmmm, where do you find the time? someone pays you to do that? can >>> they pay >> others too? >> >>> >>>> 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? >>> >>> >>> Well, if your code works for all databases the best thing to do >>> would be to >>> update the application's XAR on the website. To do so you would >>> need to >>> export the application from your wiki and replace the current one >>> with >>> yours. >>> >> I have not tested all databases, there is the possibility that the >> two >> changes I made have to be like this only for Oracle since not so >> many >> Databases use CLOBS for larg strings (other use text) >> >>> >>> You can use >>> > http://code.xwiki.org/xwiki/bin/view/Applications/ImportExportApplicationto >>> export the updated TODO application from your current wiki. You'll >>> need to >>> include all the pages from the original XAR file. >>> >>> You can then upload it here: >>> >>> > http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplicationDownloads#… >>> you've made sure it works fine (by installing it on a local wiki >>> for >>> instance). >>> >> >> Well, I am intrigued, I will try to find some time to test around >> and see >> but it will be a slow process. In the meantime, others could try it, >> isn't >> there anyone else using TODO list app? >> >>> >>> Please let me know if you need additional help. >>> >>> Looking forward your first contribution, >>> >>> Guillaume >>> >>> >>>> On Mon, Aug 17, 2009 at 2:31 PM, Guillaume Lerouge < > guillaume(a)xwiki.com >>>>> wrote: >>>> >>>>> Hi Nikos, >>>>> >>>>> On Mon, Aug 17, 2009 at 1:58 PM, Nikos Georgosopoulos < >>>> georgosn(a)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