NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "<pre>SELECT customdefinedfield.name, customdefinedfield.cdf_datatype, customdefinedfield.entitytype, customdefinedfield.label FROM customdefinedfield Left Join cdfvalue ON cus..."
<pre>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
</pre>
[[Category:NoPublic]]
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
</pre>
[[Category:NoPublic]]
