Sorry, missing a 't' in $context so once again: #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='$context.user' order by doc.date desc") Fabian. 2008/10/15 Fabian Pichler <[email protected]>
Hi Antonio
I had a quick look at your problem and think your right the HQL-Query is wrong. The Problem comes from the definition of the Assignee-Field in the XWiki.TodoClass. The Assignee-Field is defined as "List of Users" Property which is based on the LargeStringProperty and not the StringProperty.
Therefore try the following hql query: #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='$contex.user' order by doc.date desc")
Kind Regards, Fabian
2008/10/13 Antonio Goncalves <[email protected]>
I've tried everything but I can't make it work. I'm now using the HQL Query
Tester ( http://code.xwiki.org/xwiki/bin/view/Snippets/HQLQueryTesterSnippet) to test my HQL queries, but it looks like this snippet of code of the HQL Query Tester doesn't work either :o( Any idea to try HQL queries ? I really need to display the TODOs of the current user and it looks like it's just a query to change but I can't figure it out.
Any idea ?
Thanks, Antonio
2008/10/8 Antonio Goncalves <[email protected]>
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
-- -- Antonio Goncalves ([email protected]) Software architect
Paris JUG leader : www.parisjug.org Web site : www.antoniogoncalves.org Blog: jroller.com/agoncal LinkedIn: www.linkedin.com/in/agoncal _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
-- –––––––––––––––––––––––––––––––––––––––––
Fabian Pichler [email protected]
phone +41 61 261 67 89 fax +41 61 261 67 88 synventis gmbh Gerbergasse 30 CH - 4001 Basel
The information contained in this message may be confidential and is intended for the addressee only. Any unauthorised use, dissemination of the infor- mation, or copying of this message is prohibited.
-- ––––––––––––––––––––––––––––––––––––––––– Fabian Pichler [email protected] phone +41 61 261 67 89 fax +41 61 261 67 88 synventis gmbh Gerbergasse 30 CH - 4001 Basel The information contained in this message may be confidential and is intended for the addressee only. Any unauthorised use, dissemination of the infor- mation, or copying of this message is prohibited.