Public Interface Export Function › Analysis Objects › Analysis Tasks Related to Intersection Objects › EXPECT_EFFECT (Expected Effects) › Task

Task

List the expected effects for each process in a model.

SELECT P.NAME, F.CREATE, F.READ, F.UPDT, F.DLET, E.NAME
FROM
MODEL M,
PROCESS_DEF P,
EXPECT_EFFECT F,
ENTITY_TYPE E
WHERE
MODEL.NAME = ‘my model name’
AND P.MODEL_ID = M.ID
AND E.MODEL_ID = M.ID
AND F.ACTIVITY_ID = P.ID
AND F.ENTITY_ID = E.ID;