[jboss-user] [jBPM] - Re: The Data in the processInstanceinfo table get removed.

[Murat Kilic]

Murat Kilic [https://community.jboss.org/people/mkilic] created the discussion

"Re: The Data in the processInstanceinfo table get removed."

To view the discussion, visit: https://community.jboss.org/message/827802#827802

--------------------------------------------------------------
But the information in the VariableInstanceLog is not accurate:
1. Everything is converted to string
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. 
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

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) . 

I am using 5.4, by the way.

Thanks!
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/827802#827802]

Start a new discussion in jBPM at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034]

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jboss-user/attachments/20130712/1d003d59/attachment.html