Does any one has a mapping of tables in Bonita database?

Q&A
1

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

1 Like
2

Simple debugging technique, break the problem down

Have you tried just the select statement?

select * from PROCESS_INSTANCE, FLOWNODE_INSTANCE,USER_,ACTOR

Is there any data there? If yes then add ONE where clause…if not then come back to us…then try the next, then the next…

It could be that your parameters are invalid…

regards