[jbpm-dev] jbpm-BAM questions

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 [cid:part1.08040608.03040108@modinter.com.ec] 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@modinter.com.ec<mailto:burkhard.vogel@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.