Public Interface Export Function › Planning Objects › Planning Tasks › OBJECT_CLASS (System- and User-defined) › Task

Task

Select each system‑defined matrix, class name of X axis, PI table name for class on X axis, class name of Y axis, and PI table name of Y axis. Order by name of matrix.

SELECT MT.NAME, CX.NAME, CX.PI_NAME, CY.NAME, CY.PI_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;