15 Oct
2008
15 Oct
'08
8:58 a.m.
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 <fabian.pichler(a)synventis.com>
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 <antonio.mailing(a)gmail.com>
I've tried everything but I can't make it work. I'm now using the HQL Query
--
–––––––––––––––––––––––––––––––––––––––––
Fabian Pichler fabian.pichler(a)synventis.com
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.
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 <antonio.mailing(a)gmail.com>
--
–––––––––––––––––––––––––––––––––––––––––
Fabian Pichler fabian.pichler(a)synventis.com
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.
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.id and
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 (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