Useful Queries › Domains Not Used by Attributes

Domains Not Used by Attributes

Example: Query for returning a list of domains not used by attributes

Note: This report will contain domains that are used indirectly through domain inheritance.

SELECT NAME 
FROM DOMAIN
WHERE ID@ NOT IN (SELECT PARENT_DOMAIN_REF FROM ATTRIBUTE)

Example: Query for returning a list of domains not used by attributes, excluding domains that are used by other domains

SELECT NAME 
FROM DOMAIN
WHERE ID@ NOT IN 
(

SELECT PARENT_DOMAIN_REF FROM ATTRIBUTE
UNION
SELECT PARENT_DOMAIN_REF FROM DOMAIN

)