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-Collaborative-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
