Additional Queries › Work Attributes and Work Attribute Sets › Work Attribute Set Description › Query for Work Attribute Sets with a Description › Query for Work Attribute Sets Without a Description

Query for Work Attribute Sets Without a Description

SELECT M.NAME, M.CR_DATE, M.CR_TIME, B.NAME,
 FROM
 MODEL M,
 SYS_ENT_TYPE B,
 WHERE
 M.NAME='my model name'
 AND M.ID=B.MODEL_ID
 AND B.ID NOT IN
 (SELECT D.ID
 FROM
 MODEL C,
 SYS_ENT_TYPE D,
 DESCRIPTION E,
 WHERE C.NAME='my model name'
 AND C.ID=D.MODEL_ID
 AND D.ID=E.ID)
ORDER BY B.NAME;