Hi Antonio, On Oct 16, 2008, at 7:40 AM, Antonio Goncalves wrote:
> 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. Could you do that? The main page could have a "My Todos" section and a "All Todos" section below for example. Thanks -Vincent PS: BTW this is not an application supported by the xwiki dev team. It was only done by me as a quick example for an article on TSS. > 2008/10/16 Fabian Pichler <[EMAIL PROTECTED]> > >> 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.idand >>>>>>> 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 >> > > > > -- > -- > 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 _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users
