topic Re: orderByProcessInstanceId() in Alfresco Archive

orderByProcessInstanceId()

emiliano — Tue, 23 Oct 2012 08:11:17 GMT

Hi,I would like to retrieve the list of Tasks owned by a particular user ordered by their processInstanceId, so i have used:taskService.createTaskQuery().taskAssignee(userId).orderByProcessInstanceId().asc()‍‍‍Unfortunately I found that the order isn't respected, the task with the processInstanceId

Re: orderByProcessInstanceId()

frederikherema1 — Tue, 23 Oct 2012 08:15:47 GMT

That's indeed a consequence of using ID's of type String. I'm afraid there is no workaround for this, other than sorting manually. However, the ID is an arbitrary number and by coincidence, the numbers increment trough time. When using the UUID-approach, these ID's don't increment the same way.

What is the exact need for you to order it by process-instance ID? Process-start Timing?

Re: orderByProcessInstanceId()

emiliano — Tue, 23 Oct 2012 08:34:00 GMT

What is the exact need for you to order it by process-instance ID? Process-start Timing?

Yes, I'm customizing the explorer to have inbox tasks ordered by start time of their process.
If i sort them manually the pagination of tasks will be wrong.
Are there any tricks to start the ids of execution from 1000000 instead of 1 ? This should workaround the problem for 9000000 ids

thanks
emiliano

Re: orderByProcessInstanceId()

frederikherema1 — Tue, 23 Oct 2012 08:36:40 GMT

You can alter the value of "next.dbid" in ACT_GE_PROPERTY after the engine is initialized and shut down. The next time the engine boots, the ID's will start from there…

Can't you use the task-create-time?

Re: orderByProcessInstanceId()

emiliano — Tue, 23 Oct 2012 08:58:09 GMT

You can alter the value of "next.dbid" in ACT_GE_PROPERTY after the engine is initialized and shut down. The next time the engine boots, the ID's will start from there…

Excellent, thanks a lot, i'll try it.

Can't you use the task-create-time?

My Customer wants the list of tasks sorted by process creation time, so I've to respect its wishes.

best regards
emiliano

Re: orderByProcessInstanceId()

jbarrez — Tue, 23 Oct 2012 21:45:09 GMT

My Customer wants the list of tasks sorted by process creation time, so I've to respect its wishes.

Then use the historyService to fetch the HistoricProcessInstance of your ProcessInstance. That one has a start date.