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 > users@xwiki.org > 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. _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
