<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="https://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Re: The Data in the processInstanceinfo table get removed.
</h3>
<span style="margin-bottom: 10px;">
created by <a href="https://community.jboss.org/people/mkilic">Murat Kilic</a> in <i>jBPM</i> - <a href="https://community.jboss.org/message/827802#827802">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>But the information in the VariableInstanceLog is not accurate:</p><p>1. Everything is converted to string</p><p>2. Size of the field is 255. I even tried changing the field to a higher value and it did not work. Then I found the 255 character limit is imposed by the code itself. </p><p>3. It gets updated everytime a variable is submitted such as from a human task form. So we send up having multiple records for the same variable. Yes, the one with the biggest ID is the most current one, but this is not efficient for storing variable data</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>My question is how can we keep all he variables of the process even after the process ends, so we can always query that information later. In real life, for example, someone may want to go back and check a credit application even after it was declined(say this was being questioned by a manager) . </p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>I am using 5.4, by the way.</p><p style="min-height: 8pt; height: 8pt; padding: 0px;"> </p><p>Thanks!</p></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="https://community.jboss.org/message/827802#827802">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>