Technical Clarification: Process Variable information/ History in Kogito - postgresDB

[santosh reddy]

Hi,

I am writing to provide an update regarding our current capability to track process variable history in our Kogito implementation.

After reviewing our architecture and database schema, I’ve confirmed that we do not have a VariableInstanceLog equivalent or any similar table for auditing process variables. We are not using kogito data index.

Right now we are using kogito 10.1.0, quarkus 3+ version and able to see only these tables

• business_key_mapping
• correlation_instances
• flyway_schema_history
• jbpm_user_tasks
• jbpm_user_tasks_admin_groups
• jbpm_user_tasks_admin_users
• jbpm_user_tasks_attachments
• jbpm_user_tasks_comments
• jbpm_user_tasks_deadline
• jbpm_user_tasks_deadline_timer
• jbpm_user_tasks_excluded_users
• jbpm_user_tasks_inputs
• jbpm_user_tasks_metadata
• jbpm_user_tasks_outputs
• jbpm_user_tasks_potential_groups
• jbpm_user_tasks_potential_users
• jbpm_user_tasks_reassignment
• jbpm_user_tasks_reassignment_timer
• kie_flyway_history_jbpm_user_task_storage
• kie_flyway_history_runtime_persistence
• process_instances 

Please let me know if any one have any idea on this. 

Regards

Santosh

[Abhijit Humbe]

Process variable logs are maintained in 'process_instance_variable_log' table. For that add data-audit add-on:

<dependency>
<groupId>org.kie</groupId>
<artifactId>kogito-addons-quarkus-data-audit-jpa</artifactId>
</dependency>

<dependency>
<groupId>org.kie</groupId>
<artifactId>kogito-addons-quarkus-data-audit</artifactId>
</dependency>

Abhijit Humbe

--
You received this message because you are subscribed to the Google Groups "Kogito development mailing list" group.
To unsubscribe from this group and stop receiving emails from it, send an email to kogito-developm...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/kogito-development/8898c0de-a624-4240-999a-c5b54e23bdadn%40googlegroups.com.

[santosh reddy]

Thank you Abhijit, it's working. 

Regards,

Santosh Reddy

(281) 570-8049

To view this discussion visit https://groups.google.com/d/msgid/kogito-development/CAA%3DHmHqcrN-pBpCzS4VFHbgUFYFzO687rb5uKhqduSAs3JrAgQ%40mail.gmail.com.