[jboss-dev-forums] [Design of JBoss jBPM] - Re: Process/task search based on variables

[brittm]

I would second what Ronald mentioned earlier about not trying too hard to store business keys in JBPM.  We have a need to be able to look up processes (and tasks) very quickly by any one of various business keys:  account number, order number, product number, etc.  We created a "Business Keys" table that contains a row for each process instance and records any of the appropriate business key data in the appropriate column.  All columns are indexed.

This solution is very performant.  Because JBPM has some very direct relationships between processInstance, token, and taskInstance, returning the right tasks based on those business keys is performant as well.

To populate the table, the act of starting each processInstance calls an ActionHandler that looks up all the pertinent business keys based on our business logic and domain model.

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4180333#4180333

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4180333