Public Interface Export Function › Analysis Objects › Analysis Tasks Related to Intersection Objects › ENTITY_VIEW (Entity View) › Task

Task

List all the group views and entity views of all processes. If the view is an entity view, list the entity type name also.

Note: The string of asterisks is 32 columns in length, corresponding to the length of Entity_Type Name.

SELECT P.NAME, VS.TYPE, VW.TBNAME, VW.NAME, VW.SEQH, E.NAME
  FROM
  MODEL,
  PROCESS_DEF P,
  VIEW_SET VS,
  ENTITY_VIEW VW,
  ENTITY_TYPE E
  WHERE
  MODEL.NAME = 'my model name'
  AND P.MODEL_ID = MODEL.ID
  AND E.MODEL_ID = MODEL.ID
  AND VS.ACTIVITY_ID = P.ID
  AND VW.VIEW_SET_ID = VS.ID
  AND VW.ENTITY_ID = E.ID
UNION
SELECT P.NAME, VS.TYPE, VW.TBNAME, VW.NAME, VW.SEQH,
  '********************************'
  FROM
  MODEL,
  PROCESS_DEF P,
  VIEW_SET VS,
  GROUP_VIEW VW
  WHERE
  MODEL.NAME = 'my model name'
  AND P.MODEL_ID = MODEL.ID
  AND VS.ACTIVITY_ID = P.ID
  AND VW.VIEW_SET_ID = VS.ID
ORDER BY 1, 2, 5;