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

Task

Select all attributes with a permitted value range. Order by attribute name.

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

Note: For permitted values that are not a range, the low value and high value are equal.