Previous Topic: Work Attribute Set DescriptionNext Topic: Query for Work Attribute Sets Without a Description


Query for Work Attribute Sets with a Description

SELECT M.NAME, M.CR_DATE, M.CR_TIME, M.CR_USERID, B.NAME, D.TEXT,
 FROM
 MODEL M,
 SYS_ENT_TYPE B,
 DESCRIPTION C,
 WHERE M.NAME='my model name'
 AND M.ID=B.MODEL_ID
 AND B.ID=D.ID
ORDER BY B.NAME;