CDF display format: Difference between revisions
Jump to navigation
Jump to search
Created page with "<pre>SELECT `field`. fieldtype, `field`.display_mechanism, customdefinedfield.cdf_datatype, Count(`field`.field_guid) FROM customdefinedfield Inner Join `field` ON `field`.cdf..." |
No edit summary |
||
| Line 15: | Line 15: | ||
`field`.display_mechanism ASC, | `field`.display_mechanism ASC, | ||
customdefinedfield.cdf_datatype ASC | customdefinedfield.cdf_datatype ASC | ||
---------------------------------------------------------------------- | |||
UPDATE `field` | |||
SET `field`.display_mechanism = NULL | |||
WHERE `field`.display_mechanism = '' | |||
</pre> | </pre> | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
Revision as of 16:48, 10 February 2014
SELECT `field`. fieldtype, `field`.display_mechanism, customdefinedfield.cdf_datatype, Count(`field`.field_guid) FROM customdefinedfield Inner Join `field` ON `field`.cdf_guid = customdefinedfield.cdf_id GROUP BY `field`.fieldtype, `field`.display_mechanism, customdefinedfield.cdf_datatype ORDER BY `field`.fieldtype ASC, `field`.display_mechanism ASC, customdefinedfield.cdf_datatype ASC ---------------------------------------------------------------------- UPDATE `field` SET `field`.display_mechanism = NULL WHERE `field`.display_mechanism = ''