How to find the dependent toolkits hierarchy in IBM BPM? I want the details as mentioned in the diagram below. Is there any way in LSW tables or system APIs ?

Question

Answer 1

Hey Ganesh, 

There is a REST call Project Application Settings, you can find your toolkit dependencies at the section projDeps of the result return.

Thanks, 
Tung

Answer 2

Hello Ganesh,

It is possible to find dependencies from LSW tables a related query is below you can try modifying it

SELECT DISTINCT LP."NAME" PROJECT_NAME, LP.SHORT_NAME, LP.IS_SYSTEM, LP.IS_ARCHIVED, LP.IS_HIDDEN, LUX.USER_NAME as CREATED_BY, LUX1.USER_NAME MODIFIED_BY, LP.LAST_MODIFIED, count(distinct LP1.PROJECT_ID) TOOLKIT_COUNT

FROM LSW_PROJECT LP1, LSW_SNAPSHOT SNAP1, LSW_BRANCH BRANCH1, LSW_PROJECT_DEPENDENCY LPD, LSW_PO_VERSIONS LPV, LSW_BRANCH BRANCH, LSW_PROJECT LP, LSW_PO_VERSIONS LPV1, LSW_USR_XREF LUX, LSW_USR_XREF LUX1, LSW_SNAPSHOT SNAP

WHERE "BRANCH1".PROJECT_ID = SNAP1.PROJECT_ID

AND LP1.PROJECT_ID = SNAP1.PROJECT_ID

AND SNAP1.BRANCH_ID = LPV1.BRANCH_ID

AND SNAP1.PROJECT_ID = BRANCH1.PROJECT_ID 

AND BRANCH1.BRANCH_ID = LPV1.BRANCH_ID 

AND LPV1.END_SEQ_NUM = 999999999999 

AND LPV.END_SEQ_NUM(+) = 999999999999

AND SNAP1.SNAPSHOT_ID = LPD.TARGET_SNAPSHOT_ID(+)

AND LPD.VERSION_ID = LPV.PO_VERSION_ID(+)

AND LPV.BRANCH_ID = BRANCH.BRANCH_ID(+)

AND "BRANCH".PROJECT_ID = LP.PROJECT_ID(+)

AND SNAP.BRANCH_ID = LPV.BRANCH_ID(+)

AND SNAP.PROJECT_ID = BRANCH.PROJECT_ID(+)

ANd SNAP.SNAPSHOT_ID like ?

AND LP1.IS_TOOLKIT = 'T'

AND LP.CREATED_BY_USER_ID = LUX.USER_ID

AND LP.LAST_MODIFIED_BY_USER_ID = LUX1.USER_ID

AND ((SNAP1.SNAPSHOT_ID = "BRANCH1".TIP_SNAPSHOT_ID AND SNAP1."NAME" is NULL) OR SNAP1.NAME is not null)

GROUP BY LP."NAME", LP.SHORT_NAME, LP.IS_SYSTEM, LP.IS_ARCHIVED, LP.IS_HIDDEN, LUX.USER_NAME, LUX1.USER_NAME, LP.LAST_MODIFIED),