Introduction › Text Strings › Text Stored in TEXT View and Text Column › Example for This Type

Example for This Type

To select all attributes with a permitted value and 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.