Public Interface Export Function › Planning Objects › Planning Tasks › MATRIX_USAGE_Y (Usage for Y Axis) › Task

Task

Select the entity types along the Y axis of the matrix ENTITY_TYPE/ENTITY_TYPE. Order by entity type as specified in toolset.

SELECT MT.NAME, Y.NAME. UY.SEQ
  FROM
  MODEL M,
  MATRIX MT,
  MATRIX_USAGE_Y UY,
  ENTITY_TYPE Y
  WHERE
  M.NAME = 'my model name'
  AND UY.MODEL_ID = M.ID
  AND UY.MATRIX_ID = MT.ID
  AND MT.NAME = 'ENTITY_TYPE/ENTITY_TYPE'
  AND UY.OBJECT_ID = Y.ID
ORDER BY MT.NAME, UY.SEQ;