0

Process App information is stored in LSW_PROJECT table Human services and other "tasks" are designed in Process Designer to the Process App. I believe these are stored in LSW_PROCESS and LSW_PROCESS_ITEM.

How do I make a query associating a Process App to the services included in that App?

What is the significance of LSW_TASK table?

Is there any documentation which describe the tables used in IBM BPM ?

JoshMc
  • 10,239
  • 2
  • 19
  • 38
Sagar Thorat
  • 1
  • 2

1 Answers1

0

Querying the product database tables is not a supported method in IBM BPM. The database schema is not documented in the BPM knowledge center. There are REST API and Java Script API method to obtain information about the projects (which are stored in LSW_PROJECT). For the JS API, you could go through all process apps with the getAllProcessApps or the REST API with GET /rest/bpm/wle/v1/processApps

The LSW_TASK table holds information about the tasks which people (users) or the system processes. These are created for each activity on a BPD diagram. These are then deleted with the BPDProcessInstanceCleanup command is run.

If you describe your what problem you are trying to solve, I can direct you to specific resources that may already exist.

Mark Filley
  • 163
  • 2
  • 2
  • 8
  • Further if you are on a newer release you could use https://www.ibm.com/support/knowledgecenter/SS964W/com.ibm.wbpm.ref.doc/topics/rref_bpmtaskscleanup.html to cleanup tasks. Starting with 8.5.7.0 you could use the BPMProcessInstancesPurge command to delete tasks and processes. – Florian Biesinger Apr 04 '16 at 07:20