Changes

CDF missing in field

588 bytes added, 17:46, 10 February 2014

Created page with "<pre>SELECT customdefinedfield.name, customdefinedfield.cdf_datatype, customdefinedfield.entitytype FROM customdefinedfield Left Join `field` ON customdefinedfield.cdf_id = `f..."

<pre>SELECT
customdefinedfield.name,
customdefinedfield.cdf_datatype,
customdefinedfield.entitytype
FROM
customdefinedfield
Left Join `field` ON customdefinedfield.cdf_id = `field`.cdf_guid
WHERE
`field`.cdf_guid IS NULL

-----------------------------------------------------------------------

SELECT
`field`.property_name,
`field`.fieldtype,
`field`.display_mechanism,
`field`.cdf_guid
FROM
customdefinedfield
Right Outer Join `field` ON customdefinedfield.cdf_id = `field`.cdf_guid
WHERE
customdefinedfield.cdf_id IS NULL AND
`field`.cdf_guid IS NOT NULL

</pre>
[[Category:NoPublic]]

• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits