[jbpm-dev] jbpm-BAM questions

[Mauricio Salatino]

sure.. if you extend/configure the bam module to store that information you
will be able to do all the queries that you need to find all those
relationships.
Don't try to do that queries to the runtime tables that are optimized and
store binary data.
Try also to avoid loading the process instance to do that kind of queries
that can be easily externalized into another database or data structure that
is more suited to answer those queries.

Cheers

On Thu, Aug 11, 2011 at 2:46 PM, Burkhard Vogel <
Burkhard.Vogel at modinter.com.ec> wrote:

>  Hi,
> I checked my process instance info table and all states are in 1 - what
> would be a condition that this changes to 2 (suspended) or 3 (ended) as
> currently all ended instances get deleted - is there a configuration option
> to accumulate these in a history table?
>
> Related to this - the only way to drill down from an process instance to
> the bottom most sub process instances current task is by loading it into the
> knowledge session and manually check if the node implements a subprocessnode
> instance and load that sub process instance and so forth until I get the
> last node which hasn't a node log with type 1? Would there be a way to
> query from the process/node logs the current sub-process and current node?
>
> To rephrase: I have the requirement to show in which state a current
> process is - which with the current console tools will only go as far as the
> parent flows current node - but that are almost always sub-processes, so
> what I'd need is a way to build a query (or a set of queries) that would
> reflect the current process instance hierarchy and the current bottom most
> process/node.
> I CAN do this by reading all current instances of a given parent task and
> afterwards do the individual drill-down until I reach the bottom most sub
> task - but this is desperately slow for thousands of instances, so I'm
> looking for a DB select as I reckon all the info is in the audit tables.
>
> Best regards,
> Burkhard
> --
>
> Saludos cordiales,
>
> *Burkhard Vogel*
> *Lead Strategic Development*
>
>
> [image: modinter]
> *Centre of Sales & Support • Quito, Ecuador*
>
> Leonidas Plaza N24-318 y Baquerizo Moreno
> Edificio Plaza 246
> Phone:   +593 2 2237393 ext 7300
>
> Mobile:   +593 9 5771800
> E-mail:    burkhard.vogel at modinter.com.ec
>
> *www.modinter.com.ec* <http://www.modinter.com.ec/>
>
> The information in this e-mail and any attachments is confidential and is
> intended for the addressee only and may contain confidential, proprietary or
> legally privileged information. If you are not the intended recipient,
> please delete this message and any attachments and advise the sender by
> return e-mail. Unless otherwise stated, any pricing or deliver information
> given in this message is indicative only, is subject to change and to formal
> communication.
> FISA GROUP and each or any of its operating companies reserve the right to
> monitor all e-mail communication through its networks.
>
> _______________________________________________
> jbpm-dev mailing list
> jbpm-dev at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/jbpm-dev
>
>


-- 
 - CTO @ http://www.plugtree.com
 - MyJourney @ http://salaboy.wordpress.com
 - Co-Founder @ http://www.jbug.com.ar

 - Salatino "Salaboy" Mauricio -
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/jbpm-dev/attachments/20110811/f576bdac/attachment.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: image/jpg
Size: 2118 bytes
Desc: not available
Url : http://lists.jboss.org/pipermail/jbpm-dev/attachments/20110811/f576bdac/attachment.jpg