0 votes
586 views
in Toolkits by (230 points)

2 Answers

0 votes
by (860 points)
selected by
 
Best answer

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

0 votes
by (16.3k points)

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),

Related questions

0 votes
1 answer 551 views
0 votes
1 answer 993 views
0 votes
0 answers 16 views
0 votes
0 answers 120 views

624 questions

495 answers

95 comments

2.1k users

Welcome to BPM Tips Q&A, Community wiki/forum where you can ask questions and receive answers from other IBM BPM experts and members of the community. Users with 2000 points will automatically be promoted to expert level.
Created by Dosvak LLC
Our Youtube Channel
...