Try: #set ($hql = ", BaseObject as obj, StringProperty as prop1, LargeStringProperty as prop2, DateProperty as dueDate 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' and obj.id = dueDate.id.id and dueDate.id.name='TargetDate' order by dueDate.value desc")
Fabian. 2008/10/15 Antonio Goncalves <[EMAIL PROTECTED]> > Thanks Fabian, it works, that's great. > I would have a second question though. The TODOs are ordered by doc.date > (which is the creation of the document). What I really want is to order by > the Target Date (it's the property of the TodoClass). This property is a > date, so do you know how I can order by this property ? > > Thanks in advance > Antonio > > 2008/10/15 Fabian Pichler <[EMAIL PROTECTED]> > > > 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.idand > > >> > 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. > > > > > > > > > > > > > > > > > > -- > > ––––––––––––––––––––––––––––––––––––––––– > > > > 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 > > > > > > -- > -- > 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
