0 votes
136 views
in Toolkits by (120 points)

2 Answers

0 votes
by (560 points)

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.2k 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 391 views
0 votes
1 answer 800 views
0 votes
0 answers 82 views
0 votes
1 answer 407 views

602 questions

493 answers

91 comments

1.9k users

Dosvak IBM BPM /BAW Products, Download Evaluation
Process & Performance Tools Process & Performance Tools
Code Analyzer Code Analyzer
UI Toolkit UI Toolkit
Integration Monitoring Integration Monitoring
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
...