CDF not used

From IMSMA Wiki
Revision as of 17:15, 12 February 2014 by Alnaucler (talk | contribs)
Jump to navigation Jump to search
SELECT
customdefinedfield.name,
customdefinedfield.cdf_datatype,
customdefinedfield.entitytype,
customdefinedfield.label
FROM
customdefinedfield
Left Join cdfvalue ON customdefinedfield.cdf_id = cdfvalue.cdf_id
WHERE
cdfvalue.cdf_id IS NULL 
ORDER BY
customdefinedfield.entitytype ASC,
customdefinedfield.name ASC