17 Aug
2009
17 Aug
'09
4:30 p.m.
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 <guillaume(a)xwiki.com>wrote;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
_______________________________________________
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