NoPublic, bureaucrat, administrator
6,632
edits
Changes
Created page with "<pre>SELECT customdefinedfield.entitytype, customdefinedfield.cdf_datatype, customdefinedfield.name, cdfvalue.stringvalue, cdfvalue.numbervalue, cdfvalue.datevalue, cdfvalue.o..."
<pre>SELECT
customdefinedfield.entitytype,
customdefinedfield.cdf_datatype,
customdefinedfield.name,
cdfvalue.stringvalue,
cdfvalue.numbervalue,
cdfvalue.datevalue,
cdfvalue.organisation_value,
cdfvalue.place_value,
cdfvalue.gazetteer_value,
Count(cdfvalue.cdfvalue_guid)
FROM
cdfvalue
Inner Join customdefinedfield ON customdefinedfield.cdf_id = cdfvalue.cdf_id
WHERE
(cdfvalue.stringvalue IS NULL OR
cdfvalue.stringvalue = '') AND
cdfvalue.numbervalue IS NULL AND
cdfvalue.datevalue IS NULL AND
cdfvalue.organisation_value IS NULL AND
cdfvalue.place_value IS NULL AND
cdfvalue.gazetteer_value IS NULL
GROUP BY
customdefinedfield.entitytype,
customdefinedfield.cdf_datatype,
customdefinedfield.name,
cdfvalue.stringvalue,
cdfvalue.numbervalue,
cdfvalue.datevalue,
cdfvalue.organisation_value,
cdfvalue.place_value,
cdfvalue.gazetteer_value
</pre>
[[Category:NoPublic]]
customdefinedfield.entitytype,
customdefinedfield.cdf_datatype,
customdefinedfield.name,
cdfvalue.stringvalue,
cdfvalue.numbervalue,
cdfvalue.datevalue,
cdfvalue.organisation_value,
cdfvalue.place_value,
cdfvalue.gazetteer_value,
Count(cdfvalue.cdfvalue_guid)
FROM
cdfvalue
Inner Join customdefinedfield ON customdefinedfield.cdf_id = cdfvalue.cdf_id
WHERE
(cdfvalue.stringvalue IS NULL OR
cdfvalue.stringvalue = '') AND
cdfvalue.numbervalue IS NULL AND
cdfvalue.datevalue IS NULL AND
cdfvalue.organisation_value IS NULL AND
cdfvalue.place_value IS NULL AND
cdfvalue.gazetteer_value IS NULL
GROUP BY
customdefinedfield.entitytype,
customdefinedfield.cdf_datatype,
customdefinedfield.name,
cdfvalue.stringvalue,
cdfvalue.numbervalue,
cdfvalue.datevalue,
cdfvalue.organisation_value,
cdfvalue.place_value,
cdfvalue.gazetteer_value
</pre>
[[Category:NoPublic]]
