topic Re: Get last value of process variable in Alfresco Archive

Get last value of process variable

dominik_eisenbe — Tue, 14 May 2013 07:52:48 GMT

Hi,i have a problem getting the last value of process variables after the process execution has finished.First i tried, to request all historic variables, but some variables are included multiple times in the response of the following request, differing only in its Id and Value:<code lang="java"

Re: Get last value of process variable

jbarrez — Tue, 14 May 2013 08:16:25 GMT

> I also tried to use historic detailed query, to get variable updates, ordered by time, but unfortunately some variable updates occured at exactly the same timestamp.

That is probably up to your database not supporting such precision. Which db are you using?

> Is it a rule, that the id of historic variables and historic variable updates is allways incremented? Could this be a workaround for me?

Yes it is

Re: Get last value of process variable

dominik_eisenbe — Tue, 14 May 2013 10:28:41 GMT

Thanks, that helps me for the moment.

I am using Postgres 9.2

Re: Get last value of process variable

jbarrez — Wed, 15 May 2013 13:26:50 GMT

Hmm postgres is usually pretty good with time information. Can you check the column type and its precision? I kinda don't believe your machines is faster than the precision of a time column 😉