Changes

CDF missing in field

255 bytes added, 17:52, 12 February 2014

no edit summary

This query check if all records in ''customdefinedfield'' are in ''field''<pre>SELECT

customdefinedfield.name,

customdefinedfield.cdf_datatype,

WHERE

`field`.cdf_guid IS NULL

</pre>

-----------------------------------------------------------------------This query check if all CDF records in ''field'' are in ''customdefinedfield''<pre>

SELECT

`field`.property_name,

WHERE

customdefinedfield.cdf_id IS NULL AND

`field`.cdf_guid IS NOT NULL AND(`field`.fieldtype = 'cdf' OR`field`.fieldtype = 'select_cdf')ORDER BY`field`.fieldtype ASC

</pre>

Note: This query is in 5.x format

[[Category:NoPublic]]

[[Category:SQL Queries]]

• ← Older edit
• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits