NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "<pre>SELECT customdefinedfield.entitytype, customdefinedfield.cdf_datatype, customdefinedfield.name, customdefinedfield.label, allowed_value_set.value, Count(allowed_value_set..."
<pre>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
</pre>
[[Category:NoPublic]]
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
</pre>
[[Category:NoPublic]]
