0 votes
273 views
in Toolkits by (190 points)

2 Answers

0 votes
by (16.5k points)
selected by
 
Best answer

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

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

Related questions

0 votes
1 answer 431 views
0 votes
1 answer 864 views
0 votes
0 answers 96 views
0 votes
1 answer 451 views

610 questions

493 answers

91 comments

1.9k 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
...