I have bonita database set up on Oracle database, and processes deployed on bonita portal. I am having trouble figuring out to which table in database does data maps to?
This is the query I am using:
select * from PROCESS_INSTANCE, FLOWNODE_INSTANCE,USER_,ACTOR
FLOWNODE_INSTANCE.ASSIGNEEID = USER_.ID
and FLOWNODE_INSTANCE.ACTORID = ACTOR.ID
and PROCESS_INSTANCE.ID = FLOWNODE_INSTANCE.ROOTCONTAINERID
This is returning null data even though process is running on the portal. Thank you.