Hi everybody,
I've installed the Todo application (
http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplicationDownloads).
I can add new todos, affect them to users and so on. But when I check the
MyTodos Panel (
http://localhost:8080/xwiki/bin/view/Panels/MyTodos) it's
always empty. The problem is the HQL statement. It's like that :
#set ($hql = ", BaseObject as obj, StringProperty as prop1, StringProperty
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='$context.user' order by doc.date desc")
And if I get rid of the last assignee close (and obj.id=prop2.id.id and
prop2.id.name='Assignee' and prop2.value='$context.user' ), it works but
shows all the todos of everybody.
Do you know how to fix this HQL query so it shows the todos of the current
user ?
Thanks,
Antonio