How to check PM/PR files are mapped to how many objects(Applets/view/....etc)
Suppose we have to modify "ActivityFormAppletPR" but before that we have to do impact analysis to check whether this PR has been used in how many objects so for that we can run a sql query which will provide us the details of the objects where this PR is getting used.
Below is the query:
select unique D.INACTIVE_FLG,D.NAME
from S_UI_OBJECT D,S_UI_OBJ_EXPR C,S_UI_OBJ_EXP_FL B,S_UI_FILE A
where D.ROW_ID = C.UI_OBJECT_ID AND C.ROW_ID = B.UI_OBJ_EXPR_ID AND
B.UI_FILE_ID = A.ROW_ID AND A.NAME like '%NAME_OF_FILE%'
Benefits:
1. This will eliminate the issue in which multiple objects are mapped to PR/PM
2. It will save time to manually search the objects
Suppose we have to modify "ActivityFormAppletPR" but before that we have to do impact analysis to check whether this PR has been used in how many objects so for that we can run a sql query which will provide us the details of the objects where this PR is getting used.
Below is the query:
select unique D.INACTIVE_FLG,D.NAME
from S_UI_OBJECT D,S_UI_OBJ_EXPR C,S_UI_OBJ_EXP_FL B,S_UI_FILE A
where D.ROW_ID = C.UI_OBJECT_ID AND C.ROW_ID = B.UI_OBJ_EXPR_ID AND
B.UI_FILE_ID = A.ROW_ID AND A.NAME like '%NAME_OF_FILE%'
Benefits:
1. This will eliminate the issue in which multiple objects are mapped to PR/PM
2. It will save time to manually search the objects
No comments:
Post a Comment