topic Re: Lastest task at the top of task list (sort by descending) in Alfresco Archive

Lastest task at the top of task list (sort by descending)

limcheekin — Sat, 02 Oct 2010 13:16:06 GMT

Hi,Is there any way to display latest task as top most record of task list? As all Id. fields such as taskId, executionId and processInstanceId is VARCHAR type in database, TaskQuery.orderByxxxId() is not functioning properly. Please see the attached image, it is order by taskId in descending order,

Re: Lastest task at the top of task list (sort by descending)

jbarrez — Mon, 04 Oct 2010 09:08:53 GMT

That's actually a very interesting thing you discovered there, I hadn't thought about it like that …but it makes definitely sense.

I added a Jira to track this: http://jira.codehaus.org/browse/ACT-207

Re: Lastest task at the top of task list (sort by descending)

limcheekin — Mon, 04 Oct 2010 10:55:49 GMT

Hi Joram,

Thanks to create the jira to track it.

Regards,
Chee Kin

Re: Lastest task at the top of task list (sort by descending)

limcheekin — Fri, 05 Nov 2010 04:19:47 GMT

Hi Joram,

That's actually a very interesting thing you discovered there, I hadn't thought about it like that …but it makes definitely sense.

I added a Jira to track this: http://jira.codehaus.org/browse/ACT-207

Will this feature be implemented in next release?

Regards,
Chee Kin

Re: Lastest task at the top of task list (sort by descending)

jbarrez — Fri, 05 Nov 2010 13:44:54 GMT

Hi Chee,

I understand your need for it, but it will not be implemented since there is not much demand for it (yet).

It's also a pretty costly database operation, database-wise so it should not be a default.
Can't u order by default on the create time? It will give you the same sorting as sorting on id.

Re: Lastest task at the top of task list (sort by descending)

limcheekin — Sat, 06 Nov 2010 03:49:20 GMT

Hi Chee,

I understand your need for it, but it will not be implemented since there is not much demand for it (yet).

It's also a pretty costly database operation, database-wise so it should not be a default.
Can't u order by default on the create time? It will give you the same sorting as sorting on id.

Hi Joram,

Thanks for writing.

Yes, I can order it by create time. I post the previous message due to the reason that I cannot find orderByCreateTime in TaskQuery Javadoc at http://activiti.org/javadocs/org/activiti/engine/task/TaskQuery.html. Should I create a jira?

Regards,
Chee Kin

Re: Lastest task at the top of task list (sort by descending)

jbarrez — Mon, 08 Nov 2010 14:54:46 GMT

You are correct, it should be on the TaskQuery API !

You are very welcome to create a Jira.
And also many thanks for all the other jiras you raised this release, they are really helping us getting Activiti top-notch!

Re: Lastest task at the top of task list (sort by descending)

limcheekin — Tue, 09 Nov 2010 04:32:52 GMT

You are correct, it should be on the TaskQuery API !

You are very welcome to create a Jira.
And also many thanks for all the other jiras you raised this release, they are really helping us getting Activiti top-notch!

Welcome, It is just minor tasks. A jira is created at http://jira.codehaus.org/browse/ACT-321.

Regards,
Chee Kin

Re: Lastest task at the top of task list (sort by descending)

jbarrez — Tue, 09 Nov 2010 17:15:44 GMT

Thanks. It will be fixed in the next release.