If you are using XWiki with Oracle and you have the problem that the MyTodos panel doesn't show anything on the list, edit the panel's page and enter the following code in replacement of the existing:
#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' andprop1.value<>'Finished'andobj.id=prop2.id.id andprop2.id.name='Assignee'andprop2.valuelike'$context.user' orderbydoc.datedesc")
The actual change is in the LargeStringProperty that replaces the one in the XAR written as StringProperty and the like instead of = for the prop2.value.
FOR ALL OTHER DATABASES, please test this script to see if it would work with anything else than Oracle.
georgosn, 2009/08/20 20:19
I have attached the v1.1 since I tested it with HSQL (the installer version of XWiki) and it worked just fine. Please let us know if anything else needs to be corrected in this version.
Patch for Oracle
If you are using XWiki with Oracle and you have the problem that the MyTodos panel doesn't show anything on the list, edit the panel's page and enter the following code in replacement of the existing:
#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 actual change is in the LargeStringProperty that replaces the one in the XAR written as StringProperty and the like instead of = for the prop2.value.
FOR ALL OTHER DATABASES, please test this script to see if it would work with anything else than Oracle.
I have attached the v1.1 since I tested it with HSQL (the installer version of XWiki) and it worked just fine. Please let us know if anything else needs to be corrected in this version.
Nikolaos,
This wasn't the right place to attach a new version. I have moved it to the download page.
Issues I found when testing the app with XE 6.0.1:
- doesn't have an Application Panel entry
- missing translations