Hi guys,
We are currently storing a variable (“updateDate”) in all our process instances every time we complete, save or send a message to that process instance, in order to know the time that instance changed for the last time. With that information we store all the variables of that process instance in an external system (elasticsearch) in order to perform aggregations and searches based upon that modification date (processes modified today, or yesterday, or for the last week).
The problem with updating variables so frequently it is that sometimes we get concurrency problems. Is it maybe a more straightforward way to query the last modification time of a process instance? I cannot find it… Maybe reading from some history table or some task query?
Thanks in advance…
Alfonso.