17 Aug
2009
17 Aug
'09
4:59 p.m.
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>wrote;wrote:
others
too?
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)
Hi Nikos,
On Mon, Aug 17, 2009 at 4:30 PM, Nikos Georgosopoulos <georgosn(a)gmail.com
Thanks for clarifying this, it is formed as a wiki but it could have access
rights reserved (XWiki gives the option).
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 :-)
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 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.
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
StringProperty
involved
how
--
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
On Mon, Aug 17, 2009 at 2:31 PM, Guillaume
Lerouge <guillaume(a)xwiki.com
and
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 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 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 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 you made the app work under Oracle.
Thanks,
Guillaume
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
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