StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

PO
primarykey
Id
1277108
data
AcceptedAnswerId
0
AnswerCount
0
ClosedDate
CommentCount
0
CommunityOwnedDate
CreationDate
2009-08-14T10:19:21.690
FavoriteCount
0
LastActivityDate
2009-08-14T10:19:21.690
LastEditDate
LastEditorUserId
0
OwnerUserId
47724
ParentId
1276743
PostTypeId
2
Score
0
ViewCount
0
LastEditorDisplayName
text
Body
<p>Yes, you need to use jbpm_log table if you need to get transitions. To get all proceeded nodes you only need jbpm_taskInstance table. We use HQL to get all user's transition in process. I had a task about "to know wich transition user choosed for given taskInstance". It's not a obvious way to do such thing, but i cannot invent something more clear. In my case it's not a very common action in app so it's realized in "fastest-to-code-it" way. Obviously 3 queries for single task instance in your case is not a good choose. The only docs i needed were: <a href="http://docs.jboss.org/jbpm/v3/javadoc/" rel="nofollow noreferrer">http://docs.jboss.org/jbpm/v3/javadoc/</a> for help on Jbpm classes and packages and discriminator's class list: jbpm-jpdl.jar/org.jbpm.logging.log/ProcessLog.hbm.xml (has desciption about jbpm objects - DB table mapping) This is the method's code. CriteriaSQL is our CriteriaParams wrapper. As i said it isn't best example but I also have saved plain sql queries for oracle DB if you needs it.</p> <pre><code> private String getTaskTransition(LFTaskInstance instance) { CriteriaSQL csql = new CriteriaSQL(new CriteriaParams()); String query = "SELECT l " + " FROM org.jbpm.taskmgmt.log.TaskCreateLog l " + " WHERE l.taskInstance = " + instance.getId(); Query c =((HibernateSession)em).getHibernateSession().createQuery(csql.getQueryString(query)); TaskCreateLog logEntry = (TaskCreateLog) c.uniqueResult(); int index = logEntry.getIndex(); Long token = logEntry.getToken().getId(); //Find bottom log index of transition which greater then log index of current instance creation String subQuery = "SELECT min(jbpmLog.index) " + " FROM org.jbpm.graph.log.TransitionLog as jbpmLog " + " where jbpmLog.token = trLog.token AND " + //reference to query below " jbpmLog.index > " + index; //Find transition name from its Definition by log index of made transition query = " SELECT trans.name FROM org.jbpm.graph.def.Transition as trans " + " WHERE trans.id = " + " (SELECT min(transition.id) " + " FROM org.jbpm.graph.log.TransitionLog trLog " + " WHERE trLog.token = " + token + " and trLog.index = (" + subQuery + "))"; c =((HibernateSession)em).getHibernateSession().createQuery(csql.getQueryString(query)); return (String) c.uniqueResult(); } </code></pre>
Tags
Title
singulars
PostAcceptedAnswerId
1. This table or related slice is empty.
PostParentId
1. POIn jBpm, how to get all transitions that has been taken in a flow/process?
  singulars
  PostTypePostTypeId
  PTQuestion
PostTypePostTypeId
1. PTAnswer
UserLastEditorUserId
1. This table or related slice is empty.
UserOwnerUserId
1. USVanger
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. This table or related slice is empty.
VotesPostIdCreationDate
1. This table or related slice is empty.
CommentsPostId
1. This table or related slice is empty.

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.