[xwiki-users] MyTodos not showing my todos
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
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.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 ([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
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.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 ([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 [email protected] 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.
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.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 ([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 [email protected] 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.
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.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 ([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 [email protected] 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 [email protected] 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
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.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 ([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 [email protected] 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 [email protected] 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 [email protected] 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.
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. Antonio 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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
It's me again. I'm still confused by the property classes. The dueDate is of type DateProperty. How can have the milliseconds value of that date ? I've tried to format the date, but it doesn't work. If I display $todoObj.TargetDate, it's fine, but I can manipulate it as a date ( using formatDate for exemple) #foreach ($todo in $todos) #set ($todoDoc = $xwiki.getDocument($todo)) #set ($todoObj = $todoDoc.getObject("XWiki.TodoClass")) $todoObj.TargetDate // This works $xwiki.formatDate($todoObj.TargetDate, "yymmdd") // This does'n work #end Do you know what to do to use formatDate on a DateProperty ? Thanks, Antonio 2008/10/16 Antonio Goncalves <[email protected]>
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. Antonio
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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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
-- -- 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
Antonio Goncalves wrote:
It's me again. I'm still confused by the property classes. The dueDate is of type DateProperty. How can have the milliseconds value of that date ? I've tried to format the date, but it doesn't work. If I display $todoObj.TargetDate, it's fine, but I can manipulate it as a date ( using formatDate for exemple)
#foreach ($todo in $todos) #set ($todoDoc = $xwiki.getDocument($todo)) #set ($todoObj = $todoDoc.getObject("XWiki.TodoClass"))
$todoObj.TargetDate // This works $xwiki.formatDate($todoObj.TargetDate, "yymmdd") // This does'n work #end
Do you know what to do to use formatDate on a DateProperty ?
$xwiki.formatDate($todoObj.getProperty("TargetDate").value, "yymmdd") $todoObj.TargetDate formats the date into a string. $todoObj.getProperty("TargetDate").value is the actual value of the property, which is a Date for date properties. -- Sergiu Dumitriu http://purl.org/net/sergiu/
Thanks, it's working. I just have a funny behavior now when I compare these dates with the current date (converted to milliseconds) : #if ($todoObj.getProperty("TargetDate").value.time < $xwiki.currentDate.time) Sometimes the if statement is correct and sometimes is not. When I print the values I see targetDate inferior to currentDate but the if statement is not executed. Strange. Antonio 2008/10/16 Sergiu Dumitriu <[email protected]>
Antonio Goncalves wrote:
It's me again. I'm still confused by the property classes. The dueDate is of type DateProperty. How can have the milliseconds value of that date ? I've tried to format the date, but it doesn't work. If I display $todoObj.TargetDate, it's fine, but I can manipulate it as a date ( using formatDate for exemple)
#foreach ($todo in $todos) #set ($todoDoc = $xwiki.getDocument($todo)) #set ($todoObj = $todoDoc.getObject("XWiki.TodoClass"))
$todoObj.TargetDate // This works $xwiki.formatDate($todoObj.TargetDate, "yymmdd") // This does'n work #end
Do you know what to do to use formatDate on a DateProperty ?
$xwiki.formatDate($todoObj.getProperty("TargetDate").value, "yymmdd")
$todoObj.TargetDate formats the date into a string. $todoObj.getProperty("TargetDate").value is the actual value of the property, which is a Date for date properties.
-- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list [email protected] 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
Hum, just a thought. Is it String comparaison or Long ? Do I have to cast it into Long ? 2008/10/16 Antonio Goncalves <[email protected]>
Thanks, it's working. I just have a funny behavior now when I compare these dates with the current date (converted to milliseconds) : #if ($todoObj.getProperty("TargetDate").value.time < $xwiki.currentDate.time)
Sometimes the if statement is correct and sometimes is not. When I print the values I see targetDate inferior to currentDate but the if statement is not executed. Strange.
Antonio
2008/10/16 Sergiu Dumitriu <[email protected]>
Antonio Goncalves wrote:
It's me again. I'm still confused by the property classes. The dueDate is of type DateProperty. How can have the milliseconds value of that date ? I've tried to format the date, but it doesn't work. If I display $todoObj.TargetDate, it's fine, but I can manipulate it as a date ( using formatDate for exemple)
#foreach ($todo in $todos) #set ($todoDoc = $xwiki.getDocument($todo)) #set ($todoObj = $todoDoc.getObject("XWiki.TodoClass"))
$todoObj.TargetDate // This works $xwiki.formatDate($todoObj.TargetDate, "yymmdd") // This does'n work #end
Do you know what to do to use formatDate on a DateProperty ?
$xwiki.formatDate($todoObj.getProperty("TargetDate").value, "yymmdd")
$todoObj.TargetDate formats the date into a string. $todoObj.getProperty("TargetDate").value is the actual value of the property, which is a Date for date properties.
-- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list [email protected] 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
-- -- 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
Antonio Goncalves wrote:
Hum, just a thought. Is it String comparaison or Long ? Do I have to cast it into Long ?
Just write $todoObj.getProperty("TargetDate").value.time.class $xwiki.currentDate.time.class to see the type of each term.
2008/10/16 Antonio Goncalves <[email protected]>
Thanks, it's working. I just have a funny behavior now when I compare these dates with the current date (converted to milliseconds) : #if ($todoObj.getProperty("TargetDate").value.time < $xwiki.currentDate.time)
Sometimes the if statement is correct and sometimes is not. When I print the values I see targetDate inferior to currentDate but the if statement is not executed. Strange.
Antonio
2008/10/16 Sergiu Dumitriu <[email protected]>
Antonio Goncalves wrote:
It's me again. I'm still confused by the property classes. The dueDate is of type DateProperty. How can have the milliseconds value of that date ? I've tried to format the date, but it doesn't work. If I display $todoObj.TargetDate, it's fine, but I can manipulate it as a date ( using formatDate for exemple)
#foreach ($todo in $todos) #set ($todoDoc = $xwiki.getDocument($todo)) #set ($todoObj = $todoDoc.getObject("XWiki.TodoClass"))
$todoObj.TargetDate // This works $xwiki.formatDate($todoObj.TargetDate, "yymmdd") // This does'n work #end
Do you know what to do to use formatDate on a DateProperty ?
$xwiki.formatDate($todoObj.getProperty("TargetDate").value, "yymmdd")
$todoObj.TargetDate formats the date into a string. $todoObj.getProperty("TargetDate").value is the actual value of the property, which is a Date for date properties.
-- Sergiu Dumitriu http://purl.org/net/sergiu/
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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
Both are java.lang.Long. But the pb doesn't come from the if statement. I use a sortable table. And depending on the way I sort it (by clicking on the header), I have completly random behavior (sometimes I have 3 red lines, sometimes 6... weird) <table id="todoTable" class="grid sortable filterable doOddEven" cellpadding="0" cellspacing="0" border="0"> <tr class="sortHeader"> <th>N°</th> <th>Titre</th> <th>Description</th> <th>Assignee</th> <th>Date</th> <th>Status</th> </tr> #set ($i=0) #set ($today = $xwiki.currentDate.time) #foreach ($todo in $todos) #set ($todoDoc = $xwiki.getDocument($todo)) #set ($todoObj = $todoDoc.getObject("XWiki.TodoClass")) #set ($i = $i + 1) #if ($todoObj.getProperty("TargetDate").value.time < $today) <tr style="color:White;background-color:Red;"> #else <tr> #end <td>$i</td> <td>[$todo]</td> <td>$todoObj.Description</td> <td>$todoObj.Assignee</td> <td>$todoObj.TargetDate</td> <td>$todoObj.Status</td> </tr> #end </table> Thanks, Antonio 2008/10/17 Sergiu Dumitriu <[email protected]>
Antonio Goncalves wrote:
Hum, just a thought. Is it String comparaison or Long ? Do I have to cast it into Long ?
Just write
$todoObj.getProperty("TargetDate").value.time.class $xwiki.currentDate.time.class
to see the type of each term.
2008/10/16 Antonio Goncalves <[email protected]>
Thanks, it's working. I just have a funny behavior now when I compare these dates with the current date (converted to milliseconds) : #if ($todoObj.getProperty("TargetDate").value.time < $xwiki.currentDate.time)
Sometimes the if statement is correct and sometimes is not. When I print the values I see targetDate inferior to currentDate but the if statement is not executed. Strange.
Antonio
2008/10/16 Sergiu Dumitriu <[email protected]>
Antonio Goncalves wrote:
It's me again. I'm still confused by the property classes. The dueDate is of type DateProperty. How can have the milliseconds value of that date ? I've tried to format the date, but it doesn't work. If I display $todoObj.TargetDate, it's fine, but I can manipulate it as a date ( using formatDate for exemple)
#foreach ($todo in $todos) #set ($todoDoc = $xwiki.getDocument($todo)) #set ($todoObj = $todoDoc.getObject("XWiki.TodoClass"))
$todoObj.TargetDate // This works $xwiki.formatDate($todoObj.TargetDate, "yymmdd") // This does'n work #end
Do you know what to do to use formatDate on a DateProperty ?
$xwiki.formatDate($todoObj.getProperty("TargetDate").value, "yymmdd")
$todoObj.TargetDate formats the date into a string. $todoObj.getProperty("TargetDate").value is the actual value of the property, which is a Date for date properties.
-- Sergiu Dumitriu http://purl.org/net/sergiu/ _______________________________________________ users mailing list [email protected] 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
Ok Vincent. I'm still doing some bits and pieces with the TODO application and I will update it to a 1.1 version. Antonio 2008/10/17 Vincent Massol <[email protected]>
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 > [email protected] > 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 [email protected] 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 [email protected] 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 [email protected] 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 [email protected] http://lists.xwiki.org/mailman/listinfo/users
_______________________________________________ users mailing list [email protected] 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
participants (4)
-
Antonio Goncalves -
Fabian Pichler -
Sergiu Dumitriu -
Vincent Massol