Salute Ludovic, The "concat" within the query doesn't work: It shows "Enter a value" within the lists and nothing within the task page (latest tests on xwiki 2.0, utf8)
select obj.name, concat(prop1.value, ' ', prop2.value) from BaseObject as obj, StringProperty as prop1, StringProperty as prop2, IntegerProperty as prop where obj.className='XWiki.XWikiUsers' and obj.id=prop1.id.id and prop1.id.name='first_name' and obj.id=prop2.id.id and prop2.id.name='last_name' and obj.id=prop.id.id and prop.id.name='active' and prop.value=1 order by 2 I found a work around (to be validated later): Export the IssueClass, edit external, import. Edit Inline works fine for the main form. It would be nice to offer an editor for posted comments. Thanks mb -----Original Message----- From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of Ludovic Dubost Sent: Thursday, May 21, 2009 8:02 PM To: XWiki Users Subject: Re: [xwiki-users] Extended ToDo Application Michael Beetz a écrit : > Hi Ludovic, > > - Yes, it's the query, now it's showing the first name only - that's not > really fine for a German environment ;-) > > Use concat(prop1.value, ' ', prop2.value) This is the way it should have written to be standard.. > - Editing a task leads not really to an error - the WYSIWYG just shows > #includeForm("TasksCode.IssueClassSheet") > > Ok I get it. To get wysisyg you should not use the Edit / Wysiwyg but the normal "Edit" which will lead to "Edit inline". To have wysiwyg go into the IssueClass and set the field that should get wysiwyg to be forced as wysiwyg > - The comment window allows pure wiki (1.0) code only. It's not very > comfortable for normal users to handle links, pictures and other elements. > > For now we cannot really switch to Syntax 2.0. We will need 1.9 to handle that. Ludovic > Thanks again > mb > > -----Original Message----- > From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of > Ludovic Dubost > Sent: Thursday, May 21, 2009 10:33 AM > To: XWiki Users > Subject: Re: [xwiki-users] Extended ToDo Application > > > Right.. I think it's the right thing to do to work on this application... > > Michael Beetz a écrit : > >> Hi all, >> >> I'd like to go back to my original post, see below. I am using the >> TaskManagerApplication today. However what's going on? I've discovered >> that there is slightly a bit more development on the ToDo then on the >> TaskMananger. >> >> Some open issues for the TaskManager: >> - My post Jan, 3rd "org.hibernate.QueryException: expecting ''', found >> '<EOF>' >> >> > I think it's this query that causes issue. It could be a database issue: > > select obj.name,prop1.value||' '||prop2.value from BaseObject as obj, > StringProperty as prop1, StringProperty as prop2, IntegerProperty as > prop where obj.className='XWiki.XWikiUsers' and obj.id=prop1.id.id and > prop1.id.name='first_name' and obj.id=prop2.id.id and > prop2.id.name='last_name' and obj.id=prop.id.id and > prop.id.name='active' and prop.value=1 order by 2 > > it 's in the IssueClass. You can modify it to: > > select obj.name,prop1.value from BaseObject as obj, StringProperty as > prop1, StringProperty as prop2, IntegerProperty as prop where > obj.className='XWiki.XWikiUsers' and obj.id=prop1.id.id and > prop1.id.name='first_name' and obj.id=prop2.id.id and > prop2.id.name='last_name' and obj.id=prop.id.id and > prop.id.name='active' and prop.value=1 order by 2 > > to check if this is the case. > >> - I am able to maintain tasks (setting the status, reporter, editing the >> main texts ...) using the object editor only. It fails using WYSIWYG >> >> > What error are you getting ? > > >> - The usage of comments only for the documentation of progress is a bit poor >> >> > What would you like to see there ? > > >> - Syntax 2.0 >> >> >> > We need to have our Intranet upgraded to 1.8.4 to get this done. > > Ludovic > > >> Thanks >> mb >> >> ======== May, 1st start ========== >> Hi all, >> >> There are two (three) applications handling tasks: The "Task Manager >> Application" and the "(Extended) ToDo Application". AND there is a "Wanted >> Application" ... Work Order Management, where you can create a list of >> workers, and create tasks (define properties like requester dept. and name, >> project containing the task, date of creation, details, and notes). Assign >> tasks to a worker, and track hours in each task, finally close tasks. Should >> be able to extract simple reports, like n. of open/closed tasks, min., max. >> and average hours per task, listing per requester, and per worker, etc. >> >> What's the development direction of these applications? The main advantage >> of the "Task Manager Application" is the link to a Wiki Page. This allows >> making notes, adding open issues ... to a page - the local view. The global >> view is the central list of all open issues. The two main directions to >> look for open issues. >> >> That's what I like, the question is: What's going on? >> >> Thanks >> mb >> ======== May, 1st end ========== >> >> >> >> -----Original Message----- >> From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On Behalf Of >> Vincent Massol >> Sent: Wednesday, May 20, 2009 8:53 AM >> To: XWiki Users >> Subject: Re: [xwiki-users] Extended ToDo Application >> >> Hi Ludovic, >> >> Isn't what you wanted to attach the same as >> http://code.xwiki.org/xwiki/bin/view/Applications/ >> TaskManagerApplication ? >> >> Thanks >> -Vincent >> >> On May 19, 2009, at 11:41 PM, Ludovic Dubost wrote: >> >> >> >>> We have a Task Manager we have done in our internal Wiki. It has >>> the sequential number feature. It also also to link a task to a page >>> in the Wiki. It also includes notifications and panels. >>> >>> Here is an export that is pretty raw for review. With a little bit >>> of work it could be made available as a download. >>> >>> We could improve it with the LiveTable grid >>> >>> Ludovic >>> >>> Michael Beetz a écrit : >>> >>> >>>> Hello. >>>> >>>> Thanks fort he reply. >>>> >>>> Yes, I am looking for a "team-task-manager-thing" - therefore I am >>>> using the TaskManagerApplication yet. If the intention of the ToDo >>>> is different than I am still looking for the "Wanted Applications - >>>> >>>> >>>>> Work Order Management" http://code.xwiki.org/xwiki/bin/view/Applications/ >>>>> >>>>> >>>> It pretty fine and easy to link a ToDo to a parent page. The >>>> disadvantage is a huge number of pages within the tree. I do not >>>> know the XWike design principles in detail. Therefore I couldn't >>>> suggest simply the parent relation or a specific link. From the >>>> functional point of view: I'd like to have a local view for the >>>> thinks to be done on a specific area / page / process ... and the >>>> global view "who is involved / assigned on which issue". >>>> >>>> List all by ... Ses, the ToDo.WebHome is doing that. >>>> >>>> Create a ToDo based on a sequential number within a space: Having >>>> a lot of ToDos needs numbering it. That's the main request. And >>>> it would be fine to a have different groups for different spaces >>>> (10000 - 19999 for ToDos within space XYZ, 20000 - 29999 for ToDos >>>> within space ABC). >>>> >>>> Thanks again >>>> mb >>>> >>>> -----Original Message----- >>>> From: users-boun...@xwiki.org [mailto:users-boun...@xwiki.org] On >>>> Behalf Of M Rawash >>>> Sent: Tuesday, May 19, 2009 12:45 AM >>>> To: users@xwiki.org >>>> Subject: Re: [xwiki-users] Extended ToDo Application >>>> >>>> On Sun, 2009-05-10 at 09:42 +0200, Michael Beetz wrote: >>>> >>>> >>>>> Hi all, >>>>> >>>>> >>>>> >>>> hello. >>>> >>>> >>>> >>>> >>>>> The Extended ToDo Application seams to be the more active >>>>> application (than the Task Manager Application). Is there any way >>>>> to add these nice features to that application too? >>>>> - "create a todo linked to a page" >>>>> >>>>> >>>>> >>>> you mean like having a wiki page as the todo's parent (a la >>>> TaskManager) >>>> or making reference to another wiki page in the todo's body? >>>> >>>> >>>> >>>> >>>>> - "list all todos by page / by assignee / by reporter" >>>>> >>>>> >>>>> >>>> doesn't Todo.WebHome already do that (except for the 'reporter' bit)? >>>> does your todo table look different from the one in the screenshot? >>>> >>>> judging from an earlier post by you, you seem to be using the >>>> ExtendedTodoApplication as a team-task-manager-thing, that's not the >>>> intended purpose, it's more of a personalised todo list, i'm even >>>> thinking of removing the 'assignee' propriety and limiting todo >>>> access >>>> to the original reporter (ideas?) >>>> >>>> >>>> >>>> >>>>> - "create a todo having a sequential number within a space" >>>>> >>>>> >>>>> >>>> can you give me an example for that? >>>> >>>> thanks, >>>> M Rawash >>>> >>>> _______________________________________________ >>>> users mailing list >>>> users@xwiki.org >>>> http://lists.xwiki.org/mailman/listinfo/users >>>> _______________________________________________ >>>> users mailing list >>>> users@xwiki.org >>>> http://lists.xwiki.org/mailman/listinfo/users >>>> >>>> >>>> >>>> >>> -- >>> Ludovic Dubost >>> Blog: http://blog.ludovic.org/ >>> XWiki: http://www.xwiki.com >>> Skype: ldubost GTalk: ldubost >>> >>> _______________________________________________ >>> users mailing list >>> users@xwiki.org >>> http://lists.xwiki.org/mailman/listinfo/users >>> >>> >> _______________________________________________ >> users mailing list >> users@xwiki.org >> http://lists.xwiki.org/mailman/listinfo/users >> _______________________________________________ >> users mailing list >> users@xwiki.org >> http://lists.xwiki.org/mailman/listinfo/users >> >> >> > > > -- Ludovic Dubost Blog: http://blog.ludovic.org/ XWiki: http://www.xwiki.com Skype: ldubost GTalk: ldubost _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users _______________________________________________ users mailing list users@xwiki.org http://lists.xwiki.org/mailman/listinfo/users