nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

As we transition to the new Hyland Community, some post links may be temporarily disrupted as we finalize redirects. We apologize for the inconvenience and are working to resolve this as quickly as possible. Details.

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

limcheekin

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, you can see that the result is incorrect.

As all Id. fields are display numeric value, why not using Long instead of String? To ensure it is unique in Clustering/Cloud environment?

Please advice.

Regards,
Chee Kin

2010-10-02_20-49-22.jpg

Find more posts tagged with

Comments

jbarrez

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

limcheekin

Hi Joram,

Thanks to create the jira to track it.

Regards,
Chee Kin

limcheekin

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

jbarrez

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.

limcheekin

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

jbarrez

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!

limcheekin

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

jbarrez

Thanks. It will be fixed in the next release.