Thanks. That is what I look for. It solves my issue.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jeremie BOUSQUET Sent: Tuesday, May 14, 2013 5:26 PM To: XWiki Users Subject: Re: [xwiki-users] Todo tutorial: how to list the document in Todo panel? Hi, I think your query might be far easier to write using XWQL instead of HQL (see http://extensions.xwiki.org/xwiki/bin/view/Extension/Query+Module#HXWQLImplementationDetails), if you want to go back to initial solution. BR, Jeremie 2013/5/13 Guofeng Zhang <[email protected]> > I solve it using the data in the object, not based on the HQL query. > > #set ($hql = ", BaseObject as obj where obj.name=doc.fullName and > obj.className='XWiki.TodoClass' and obj.name<>'XWiki.TodoTemplate' > order by doc.date desc") #foreach ($todo in > $xwiki.searchDocuments($hql, 5, 0)) > #set ($todoDoc = $xwiki.getDocument($todo)) > #set ($todoObj = $todoDoc.getObject("XWiki.TodoClass")) > #if ($todoObj.Status != 'Finished') > #set($description = $todoObj.Description) > * [[$description.replace("<p>", "").replace("</p>", "") >>$todo]] > #end > #end > > Any advice? > > -----Original Message----- > From: [email protected] [mailto:[email protected]] On > Behalf Of Guofeng Zhang > Sent: Friday, May 10, 2013 2:11 PM > To: [email protected] > Subject: [xwiki-users] Todo tutorial: how to list the document in Todo > panel? > > Hi, > > I follow the Todo tutorial ( > http://www.theserverside.com/news/1363830/XWiki-A-Platform-for-Collabo > rative-Apps) on XWiki 5.0.1. By making a little changes and using > XWiki Sytanx 2.0. The Todo application runs well on my XWiki instance. > But I stuck at My Todo Panel. > > Listing 7 in the tutorial shows the following code to list all Todo > documents on My Todo Panel assigned to the current logged in user and > that are not finished: > > #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") > > #foreach ($todo in $xwiki.searchDocuments($hql, 5, 0)) ...... > > It has the following description about the above code: > "The hard part in creating this My Todo Panel is in finding out the > correct HQL query to write. You have to know that Static List Class > properties and User Class properties are stored internally using a > StringProperty Object." > > For me on XWiki 5.0.1, no document returned by the above code and I > do not know where to start from to fix it. > > I know tutorial is old (on 1 Dec, 2007), so maybe the object store has > been changed late. > > Could you give me instructions how to make the above code work? > > It is appreciated if you could give some fix to the above code and I > like to test the fix. > > Thanks for your help. > > Guofeng > _______________________________________________ > users mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ > users mailing list > [email protected] > http://lists.xwiki.org/mailman/listinfo/users > _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list [email protected] http://lists.xwiki.org/mailman/listinfo/users
