topic Re: Sort problem on activi historic table (sort by id) in Alfresco Archive

Sort problem on activi historic table (sort by id)

lestat86 — Wed, 01 Jul 2015 13:40:43 GMT

Hi everyone,I recently discovered what might be a bug in the activity historic table (act_hi_actinst). In my application i need to display the last activity executed by a certain process, so what i've done for the past month is using this code to get it:getHistoryService().createHistoricActivityInst

Re: Sort problem on activi historic table (sort by id)

trademak — Wed, 01 Jul 2015 13:49:27 GMT

Hi Alberto,

We wanted to support alternative id generators that might not produce only numeric ids as well.
So it's not a mistake. But for these use cases a numeric column type would have been a better fit.
The best way to do sorting would be using starting and end time.

Best regards,

Re: Sort problem on activi historic table (sort by id)

lestat86 — Wed, 01 Jul 2015 14:07:44 GMT

Wow, so fast! Thanks for the reply.

I see. My problem with the end time is that sometimes the end time of very quick tasks match up to the millisecond, so it doesn't really work.
I've created a procedure based on both criteria (id and end time) and it is working, i was just curious on this choice of field type.

Thanks again!

Alberto