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