CDF not used: Difference between revisions
Jump to navigation
Jump to search
Created page with "<pre>SELECT customdefinedfield.name, customdefinedfield.cdf_datatype, customdefinedfield.entitytype, customdefinedfield.label FROM customdefinedfield Left Join cdfvalue ON cus..." |
No edit summary |
||
| Line 1: | Line 1: | ||
<pre>SELECT | <pre> | ||
SELECT | |||
customdefinedfield.name, | customdefinedfield.name, | ||
customdefinedfield.cdf_datatype, | customdefinedfield.cdf_datatype, | ||
| Line 15: | Line 16: | ||
</pre> | </pre> | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:SQL Queries]] | |||
Revision as of 17:15, 12 February 2014
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