Duplicate allow value: Difference between revisions
Jump to navigation
Jump to search
Created page with "<pre>SELECT customdefinedfield.entitytype, customdefinedfield.cdf_datatype, customdefinedfield.name, customdefinedfield.label, allowed_value_set.value, Count(allowed_value_set..." |
No edit summary |
||
| Line 1: | Line 1: | ||
<pre>SELECT | <pre> | ||
SELECT | |||
customdefinedfield.entitytype, | customdefinedfield.entitytype, | ||
customdefinedfield.cdf_datatype, | customdefinedfield.cdf_datatype, | ||
| Line 25: | Line 26: | ||
</pre> | </pre> | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:SQL Queries]] | |||
Revision as of 17:43, 12 February 2014
SELECT customdefinedfield.entitytype, customdefinedfield.cdf_datatype, customdefinedfield.name, customdefinedfield.label, allowed_value_set.value, Count(allowed_value_set.guid) FROM customdefinedfield Inner Join allowed_value_set ON customdefinedfield.cdf_id = allowed_value_set.cdf_id GROUP BY customdefinedfield.cdf_id, customdefinedfield.entitytype, customdefinedfield.cdf_datatype, customdefinedfield.name, customdefinedfield.label, allowed_value_set.value HAVING Count(allowed_value_set.guid) > '1' ORDER BY customdefinedfield.entitytype ASC, customdefinedfield.name ASC, allowed_value_set.value ASC