Duplicate CDF - Revision history

Alnaucler at 11:53, 3 July 2015

2015-07-03T11:53:22Z

← Older revision		Revision as of 13:53, 3 July 2015
Line 1:		Line 1:
			Effects of the rules are described [[Name Rules Staging Area \| here]].
	This query checks for Duplicate CDFs according to {{IMSMANG}} rules i.e. unique name (including spaces), data type per parent.		This query checks for Duplicate CDFs according to {{IMSMANG}} rules i.e. unique name (including spaces), data type per parent.
	<pre>		<pre>

Alnaucler at 08:57, 3 July 2015

2015-07-03T08:57:56Z

@@ Line 1: / Line 1: @@
 This query checks for Duplicate CDFs according to {{IMSMANG}} rules i.e. unique name (including spaces), data type per parent.
 <pre>
 PostgreSQL
 SELECT
@@ Line 22: / Line 40: @@
 This query checks for Duplicate CDFs based only on name in lower case and length 63. If you get any duplicates here, you need to double-check that the Staging area database is created correctly.
 <pre>
 PostgreSQL
 SELECT
@@ Line 41: / Line 74: @@
 This query checks for Duplicate CDFs based only on name in lower case and length 31. If you get any duplicates here, you need to double-check that the Staging area geo database is created correctly and the column names used in the geo views are not confusing.
 <pre>
 PostgreSQL
 SELECT

Alnaucler at 08:49, 3 July 2015

2015-07-03T08:49:38Z

← Older revision		Revision as of 10:49, 3 July 2015
Line 1:		Line 1:
	This query checks for Duplicate CDFs according to {{IMSMANG}} rules.		This query checks for Duplicate CDFs according to {{IMSMANG}} rules i.e. unique name (including spaces), data type per parent.
	<pre>		<pre>
			PostgreSQL
	SELECT		SELECT
	customdefinedfield.name,		"public".customdefinedfield."name",
	customdefinedfield.cdf_datatype,		"public".customdefinedfield.cdf_datatype,
	customdefinedfield.entitytype,		"public".customdefinedfield.entitytype,
	Count(customdefinedfield.cdf_id)		Count("public".customdefinedfield.cdf_id)
	FROM		FROM
	customdefinedfield		"public".customdefinedfield
	GROUP BY		GROUP BY
	customdefinedfield.name,		"public".customdefinedfield."name",
	customdefinedfield.cdf_datatype,		"public".customdefinedfield.cdf_datatype,
	customdefinedfield.entitytype		"public".customdefinedfield.entitytype
	HAVING		HAVING
	Count(customdefinedfield.cdf_id) > '1'		Count("public".customdefinedfield.cdf_id) > 1
	ORDER BY		ORDER BY
	~~customdefinedfield.entitytype ASC~~,		1, 2
	~~customdefinedfield.name ASC~~
	</pre>		</pre>

	This query checks for Duplicate CDFs based only on name and. If you get any duplicates here, you need to double-check that the Staging area database is created correctly.		{{Warning\| Depending on data type, etc. there might '''not''' be any error messages during the Staging area generation.}}
			This query checks for Duplicate CDFs based only on name in lower case and length 63. If you get any duplicates here, you need to double-check that the Staging area database is created correctly.
	<pre>		<pre>
			PostgreSQL
	SELECT		SELECT
	customdefinedfield.name,		left(lower("public".customdefinedfield."name"), 63) AS max_length,
	customdefinedfield.entitytype,		"public".customdefinedfield.entitytype,
	Count(customdefinedfield.cdf_id)		Count("public".customdefinedfield.cdf_id)
	FROM		FROM
	customdefinedfield		"public".customdefinedfield
	GROUP BY		GROUP BY
	~~customdefinedfield.name~~,		max_length,
	customdefinedfield.entitytype		"public".customdefinedfield.entitytype
	HAVING		HAVING
	Count(customdefinedfield.cdf_id) > '1'		Count("public".customdefinedfield.cdf_id) > 1
	ORDER BY		ORDER BY
	~~customdefinedfield.entitytype ASC~~,		1, 2
	~~customdefinedfield.name ASC~~
	</pre>		</pre>

			{{Warning\| Depending on data type, etc. there might '''not''' be any error messages during the Staging area geo generation.}}
			This query checks for Duplicate CDFs based only on name in lower case and length 31. If you get any duplicates here, you need to double-check that the Staging area geo database is created correctly and the column names used in the geo views are not confusing.
			<pre>
			PostgreSQL
			SELECT
			left(lower("public".customdefinedfield."name"), 31) AS max_length,
			"public".customdefinedfield.entitytype,
			Count("public".customdefinedfield.cdf_id)
			FROM
			"public".customdefinedfield
			GROUP BY
			max_length,
			"public".customdefinedfield.entitytype
			HAVING
			Count("public".customdefinedfield.cdf_id) > 1
			ORDER BY
			1, 2
			</pre>
	{{NavBox Upgrade}}		{{NavBox Upgrade}}
	[[Category:NoPublic]]		[[Category:NoPublic]]
	[[Category:SQL Queries]]		[[Category:SQL Queries]]

Alnaucler at 07:15, 8 April 2015

2015-04-08T07:15:00Z

@@ Line 1: / Line 1: @@
 <pre>
 SELECT
@@ Line 17: / Line 18: @@
 customdefinedfield.name ASC
 </pre>
 {{NavBox Upgrade}}
 [[Category:NoPublic]]
 [[Category:SQL Queries]]

Dionysia at 08:34, 13 February 2014

2014-02-13T08:34:36Z

← Older revision		Revision as of 10:34, 13 February 2014
Line 17:		Line 17:
	customdefinedfield.name ASC		customdefinedfield.name ASC
	</pre>		</pre>

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

Alnaucler at 15:58, 12 February 2014

2014-02-12T15:58:47Z

← Older revision		Revision as of 17:58, 12 February 2014
Line 1:		Line 1:
	<pre>SELECT		<pre>
			SELECT
	customdefinedfield.name,		customdefinedfield.name,
	customdefinedfield.cdf_datatype,		customdefinedfield.cdf_datatype,
Line 17:		Line 18:
	</pre>		</pre>
	[[Category:NoPublic]]		[[Category:NoPublic]]
			[[Category:SQL Queries]]

Alnaucler: Created page with "

SELECT customdefinedfield.name, customdefinedfield.cdf_datatype, customdefinedfield.entitytype, Count(customdefinedfield.cdf_id) FROM customdefinedfield GROUP BY customde..."

2014-02-10T15:49:43Z

Created page with "<pre>SELECT customdefinedfield.name, customdefinedfield.cdf_datatype, customdefinedfield.entitytype, Count(customdefinedfield.cdf_id) FROM customdefinedfield GROUP BY customde..."

New page

<pre>SELECT
customdefinedfield.name,
customdefinedfield.cdf_datatype,
customdefinedfield.entitytype,
Count(customdefinedfield.cdf_id)
FROM
customdefinedfield
GROUP BY
customdefinedfield.name,
customdefinedfield.cdf_datatype,
customdefinedfield.entitytype
HAVING
Count(customdefinedfield.cdf_id) > '1'
ORDER BY
customdefinedfield.entitytype ASC,
customdefinedfield.name ASC
</pre>
[[Category:NoPublic]]