Public Interface Export Function › Planning Objects › Planning Tasks › USER_DEF_OBJECT (User-defined Object) › Task

Task

Select user‑defined classes on the X and Y axis, and the user‑defined objects on both axis of a user‑defined matrix.

SELECT MT.NAME, CX.NAME, CY.NAME, X.NAME, UX.SEQ, Y.NAME, UY.SEQ,
.CELL_VALUE
  FROM
  MODEL M,
  MATRIX MT,
  OBJECT_CLASS CX,
  OBJECT_CLASS CY,
  MATRIX_USAGE_ UX,
  USER_DEF_OBJECT X,
  MATRIX_USAGE_Y UY,
  USER_DEF_OBJECT Y,
  CELL_VALUE V
  WHERE
  M.NAME = 'my model name'
  AND MT.MODEL_ID = M.ID
  AND MT.NAME = 'name of user-defined matrix'
  AND MT.OBJ_CLASS_X_ID = CX.ID
  AND MT.OBJ_CLASS_Y_ID = CY.ID
  AND UX.MATRIX_ID = MT.ID
  AND UX.OBJECT_ID = X.ID
  AND UY.MATRIX_ID = MT.ID
  AND UY.OBJECT_ID = Y.ID
  AND V.MATRIX_ID = MT.ID
  AND V.X_OBJECT_ID = X.ID
  AND V.Y_OBJECT_ID = Y.ID
ORDER BY MT.NAME, UX.SEQ;

Note: A user‑defined matrix can contain system‑defined object classes. The user‑defined matrix is not required to have user‑defined objects. In that case, the X and Y table would be replaced with the name of the table that contains the objects on the axis. For more information, see OBJECT_CLASS.