Get All Values for an Archived Data Instance

Submitted by gjhr1304 on Thu, 06/19/2014 - 17:44
1
0
-1

Hi,

I have a process with a form to create an entity, then a form to verify this entity's information and another form to modify any field indicated in the verification. I want to be able to show to the verifier all previous values for a field.

Is there a way to obtain all the values that a global variable has taken? I know about the archived data instances but the api methods called getArchivedActivityInstances, getArchivedProcessDataInstance and getArchivedProcessDataInstances just return the last value that the variable has.

Thanks for any help.

P.D. I'm working with Bonita community 6.2

1 answer

Submitted by Pierre-yves Monnet on Fri, 06/20/2014 - 16:31
1
0
-1

Hello,

The information are in the Bonita database, but there are no API to access it.

So, the solution is : - develop a command to access the information. The command is run on the Bonita server, so can access the command to run a SQL query to get the information. Look on tables to find where the information are. Of course, on a different BonitaVersion, the database structure may change, then the SQL on command must be check

  • use a KPI to store the information on an external database. In Community this function is not available, so you must define your own connector to save the data.

Hope this help,

Comments

Submitted by gjhr1304 on Fri, 06/20/2014 - 16:52

Thank you very much, I'm going to try this option!

Permalink
Notifications