Public Interface Export Function › Analysis Objects › Analysis Tasks Related to Data. › PARTITIONING/CLASSIFIER › Task

Task

Select entity type name, classifying attribute name, and subtype name. Order by entity type name.

SELECT E.NAME, A.NAME, S.NAME
  FROM
  MODEL M,
  ENTITY_TYPE E,
  PARTITIONING P,
  CLASSIFIER C,
  ENTITY_SUBTYP S,
  ATTRIBUTE A
  WHERE
  M.NAME = 'my model name'
  AND E.MODEL_ID = M.ID
  AND P.PARENT_ENTITY_ID = E.ID
  AND C.PARTITIONING_ID = P.ID
  AND A.ID = C.ATTRIBUTE_ID
  AND S.PARTITIONING_ID = P.ID
ORDER BY E.NAME;

Note: SQL retrieves only those rows for which all the criteria are met. This means that if a classifying attribute has not been specified for a partitioning, no information on that partitioning will be returned.