Previous Topic: IMPL_LOGIC_USAGE (Implementation Logic Usage)Next Topic: TD_LIBRARY_USAGE (Technical Design/Library Usage)


Task

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.