Public Interface Export Function › Planning Objects › Planning Tasks › MATRIX (Planning Matrices) › Task

Task

Select all the system‑defined matrices and the classes on the X and Y axes. Order by name of matrix.

SELECT MT.NAME, CX.NAME, CY.NAME
  FROM
  MODEL M,
  MATRIX MT,
  OBJECT_CLASS CX,
  OBJECT_CLASS CY
  WHERE
  M.NAME = 'my model name'
  AND MT.MODEL_ID = M.ID
  AND MT.IEF_OR_USER_SUP = 'I'
  AND MT.OBJ_CLASS_X_ID = CX.ID
  AND MT.OBJ_CLASS_Y_ID& = CY.ID
ORDER BY MT.NAME;