Public Interface Export Function › Planning Objects › Planning Tasks › CELL_VALUE (Cell Value for a Matrix) › Task

Task

Select the name of class on X axis, name of class on Y axis, name of object on X axis and its sequence, name of object on Y axis and its sequence, and the cell value for the matrix ENTITY_TYPE/ENTITY_TYPE.

SELECT MT.NAME, CX.NAME, CY.NAME, X.NAME, UX.SEQ, Y.NAME,
UY.SEQ, V.CELL_VALUE
FROM
MODEL M,
MATRIX MT,
OBJECT_CLASS CX,
OBJECT_CLASS CY,
MATRIX_USAGE_X UX,
ENTITY_TYPE X,
MATRIX_USAGE_Y, UY,
ENTITY_TYPE Y,
CELL_VALUE V
WHERE
M.NAME = ‘my model name’
AND MT.MODEL_ID = M.ID
AND MT.NAME = ‘ENTITY_TYPE/ENTITY_TYPE’
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: Objects can appear on an axis without a cell value. Such objects are not found by the SELECT.

Some matrices use other views to retrieve cell values. See the following table: