CDF display format - Revision history

Alnaucler at 17:00, 31 August 2019

2019-08-31T17:00:12Z

← Older revision		Revision as of 19:00, 31 August 2019
Line 43:		Line 43:
	\|}		\|}

			{{Note \| In 6.0 ''TEXT_FIELD'' should have value TEXT_FIELD '''or''' TEXT_AREA in ''display_mechanism''.
			}}
	{{NavBox Upgrade}}		{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 08:51, 12 July 2014

2014-07-12T08:51:46Z

@@ Line 1: / Line 1: @@
-This result set should be compared with the list of correct combinations-
+This result set should be compared with the list of correct combinations
 <pre>
 SELECT
@@ Line 18: / Line 18: @@
 customdefinedfield.cdf_datatype ASC
 </pre>
 {{NavBox Upgrade}}
 [[Category:NoPublic]]
 [[Category:SQL Queries]]

Alnaucler at 14:22, 20 May 2014

2014-05-20T14:22:15Z

← Older revision		Revision as of 16:22, 20 May 2014
Line 17:		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`~~
	~~SET `field`.display_mechanism = null~~
	~~where `field`.display_mechanism = '' AND~~
	~~`field`. fieldtype = 'cdf'~~
	</pre>		</pre>

Dionysia at 08:33, 13 February 2014

2014-02-13T08:33:45Z

← Older revision		Revision as of 10:33, 13 February 2014
Line 26:		Line 26:
	`field`. fieldtype = 'cdf'		`field`. fieldtype = 'cdf'
	</pre>		</pre>

			{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 15:19, 12 February 2014

2014-02-12T15:19:29Z

← Older revision		Revision as of 17:19, 12 February 2014
Line 21:		Line 21:
	This UPDATE query is just one of several that might need to be applied		This UPDATE query is just one of several that might need to be applied
	<pre>		<pre>
	~~UPDATE~~ `field`		Update `field`
	SET `field`.display_mechanism = ~~NULL~~		SET `field`.display_mechanism = null
	~~WHERE~~ `field`.display_mechanism = ''		where `field`.display_mechanism = '' AND
			`field`. fieldtype = 'cdf'
	</pre>		</pre>
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 15:15, 12 February 2014

2014-02-12T15:15:50Z

← Older revision		Revision as of 17:15, 12 February 2014
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]]

Alnaucler at 15:48, 10 February 2014

2014-02-10T15:48:20Z

← Older revision		Revision as of 17:48, 10 February 2014
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]]

Alnaucler: Created page with "

SELECT `field`. fieldtype, `field`.display_mechanism, customdefinedfield.cdf_datatype, Count(`field`.field_guid) FROM customdefinedfield Inner Join `field` ON `field`.cdf..."

2014-02-10T15:44:45Z

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..."

New page

<pre>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

</pre>
[[Category:NoPublic]]