I am using JBPM with postgres DB. I have found in the postgres DB the default table that is 'Processinstancelog'. This table has the 'status' column but showing the 'status' as an integer value(like 1,2,3,4,...) and have data type as integer.
Expected Requirement
My requirement is to print 'status' in actual format(text) like, completed, exited, suspended, aborted, same as we have in the Business central work bench>Menu>Manage>process instance > state
Query
I did not find how the 'integer status' is mapped with 'textual status' in the "processinstancelog" table. there is no script for this table "processinstancelog" as this is the default created table.
Question
I want to know each number is mapped to which status? so I can print the status instead of numbers.
I found from the below question that Db has no script for the table 'processinstancelog' jBPM 5: where are the db-tables-scripts?
Also here is DB table screenshot enter image description here
Here is the list of integer-text mapping of process instance status:
0 = STATE_PENDING,
1 = STATE_ACTIVE,
2 = STATE_COMPLETED,
3 = STATE_ABORTED
4 = STATE_SUSPENDED