Re: [xwiki-users] MyTodos not showing my todos

That works great thanks Fabian. IMHO the TODO application should be changed and use this HQL request instead. It makes more sense to only display the todos of the connected user and sort them by due date.

2008/10/16 Fabian Pichler &lt;fabian.pichler(a)synventis.com&gt; > 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 &lt;antonio.mailing(a)gmail.com&gt; > >> 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 &lt;fabian.pichler(a)synventis.com&gt; >> >>> 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 &lt;fabian.pichler(a)synventis.com&gt; >>> >>>> 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 &lt;antonio.mailing(a)gmail.com&gt; >>>> >>>> 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 &lt;antonio.mailing(a)gmail.com&gt; >>>>> >>>>>> Hi everybody, >>>>>> I've installed the Todo application ( >>>>>> >>>>> >>> >> >

-- -- Antonio Goncalves (antonio.goncalves(a)gmail.com) 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(a)xwiki.org http://lists.xwiki.org/mailman/listinfo/users