Public Interface Export Function › Analysis Objects › Analysis Tasks Related to Data. › PERMIT_VALUE (Permitted Values for an Attribute) › Task

Task

Select all attributes with permitted values. Order by attribute name.

SELECT A.NAME, L.VALUE
  FROM
 MODEL M,
  ATTRIBUTE A,
  PERMIT_VALUE P,
  PERMIT_VALUE_LOW L
  WHERE
  M.NAME = 'my model name'
  AND A.MODEL_ID = M.ID
  AND A.ID = P.ATTRIBUTE_ID
  AND P.LOW_VALUE = L.ID
ORDER BY A.NAME;