15 Oct
2008
15 Oct
'08
11:30 a.m.
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 <fabian.pichler(a)synventis.com>
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>
--
–––––––––––––––––––––––––––––––––––––––––
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.
_______________________________________________
users mailing list
users(a)xwiki.org
http://lists.xwiki.org/mailman/listinfo/users
--
--
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
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
> 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>
>
> > Hi everybody,
> > I've installed the Todo application (
> >
>
http://code.xwiki.org/xwiki/bin/view/Applications/TodoApplicationDownloads
).
--
–––––––––––––––––––––––––––––––––––––––––
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.
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.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 (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