CDF display format: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
<pre>SELECT | This result set should be compared with the list of correct combinations- | ||
<pre> | |||
SELECT | |||
`field`. fieldtype, | `field`. fieldtype, | ||
`field`.display_mechanism, | `field`.display_mechanism, | ||
| Line 15: | Line 17: | ||
`field`.display_mechanism ASC, | `field`.display_mechanism ASC, | ||
customdefinedfield.cdf_datatype ASC | customdefinedfield.cdf_datatype ASC | ||
</pre> | |||
This UPDATE query is just one of several that might need to be applied | |||
<pre> | |||
UPDATE `field` | UPDATE `field` | ||
SET `field`.display_mechanism = NULL | SET `field`.display_mechanism = NULL | ||
WHERE `field`.display_mechanism = '' | WHERE `field`.display_mechanism = '' | ||
</pre> | </pre> | ||
[[Category:NoPublic]] | [[Category:NoPublic]] | ||
[[Category:SQL Queries]] | |||
Revision as of 16:15, 12 February 2014
This result set should be compared with the list of correct combinations-
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
This UPDATE query is just one of several that might need to be applied
UPDATE `field` SET `field`.display_mechanism = NULL WHERE `field`.display_mechanism = ''