Select the action used to cascade delete an entity and select the action
blocks it calls directly.
SELECT ENT.NAME, ACBLK1.NAME, ACBLK2.NAME FROM MODEL M, ENTITY_TYPE ENT, CD_ACTN_BLK ACBLK1 IMPLEMENT_LOGIC IMP1 IMPL_LOGIC_USAGE USE, IMPLEMENT_LOGIC IMP2, CD_ACTN_BLK ACBLK2 WHERE M.NAME = ‘my model name‘ AND ENT.MODEL_ID = M.ID AND ACBLK1.ENTITY_ID = ENT.ID AND IMP1.ACTION_BLOCK_ID = ACBLK1.ID AND USE.IMPL_LOGIC_ID = IMP1.ID AND USE.CALLED_IMPL_ID = IMP2.ID AND IMP2.ACTION_BLOCK_ID = ACBLK2.ID ORDER BY ENT.NAME, ACBLK1.NAME, ACBLK2.NAME;
This will only select the action blocks called directly from the action block but not any other action blocks called by them.
|
Copyright © 2013 CA.
All rights reserved.
|
|