Duplicate Enumvalue SQL - Revision history

Alnaucler at 17:26, 17 June 2017

2017-06-17T17:26:24Z

← Older revision		Revision as of 19:26, 17 June 2017
Line 1:		Line 1:
	{{Warning \| Duplicate enumvalues will cause import problems that are difficult to detect because there is no error message. }}		{{Warning \| Duplicate enumvalues will cause import problems that are difficult to detect because there is no error message. }}
	{{Note \| The import problem will also ~~occur~~ in cases where one ~~enumvalue~~ is active and the ~~others~~ are inactive. The import problem does not apply to CDFs. }}		{{Note \| The import problem will also happen in cases where one enumeration value is active and the other are inactive. The import problem does not apply to CDFs. }}

	If this SQL gives a result set, your country may have had an undetected problem also during 5.x:		If this SQL gives a result set, your country may have had an undetected problem also during 5.x:

Alnaucler at 08:26, 12 July 2014

2014-07-12T08:26:45Z

← Older revision		Revision as of 10:26, 12 July 2014
Line 7:		Line 7:
	imsmaenum.enumcategory,		imsmaenum.enumcategory,
	imsmaenum.enumvalue,		imsmaenum.enumvalue,
	COUNT (imsmaenum.imsmaenum_guid)		COUNT(imsmaenum.imsmaenum_guid)
	FROM		FROM
	imsmaenum		imsmaenum
Line 14:		Line 14:
	imsmaenum.enumvalue		imsmaenum.enumvalue
	HAVING		HAVING
	COUNT (		COUNT(imsmaenum.imsmaenum_guid) > 1
	imsmaenum.imsmaenum_guid
	) > 1
	ORDER BY		ORDER BY
	imsmaenum.enumcategory ASC,		imsmaenum.enumcategory ASC,

Dionysia at 15:55, 9 July 2014

2014-07-09T15:55:19Z

← Older revision		Revision as of 17:55, 9 July 2014
Line 22:		Line 22:
	</pre>		</pre>

	{{note\|any change here must be done on the [[Duplicate_Enumvalue\|public page}]] too}}		{{note\|any change here must be done on the [[Duplicate_Enumvalue\|public page]] too}}

	{{NavBox Upgrade}}		{{NavBox Upgrade}}

Dionysia: add link to the public page

2014-07-09T15:55:03Z

add link to the public page

← Older revision		Revision as of 17:55, 9 July 2014
Line 2:		Line 2:
	{{Note \| The import problem will also occur in cases where one enumvalue is active and the others are inactive. The import problem does not apply to CDFs. }}		{{Note \| The import problem will also occur in cases where one enumvalue is active and the others are inactive. The import problem does not apply to CDFs. }}

	If this SQL gives a result set, your country may had a undetected problem also during 5.x:		If this SQL gives a result set, your country may have had an undetected problem also during 5.x:
	<pre>		<pre>
	SELECT		SELECT
Line 22:		Line 22:
	</pre>		</pre>

	(any change here must be done on the public page too)		{{note\|any change here must be done on the [[Duplicate_Enumvalue\|public page}]] too}}

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

Dionysia at 15:46, 9 July 2014

2014-07-09T15:46:50Z

← Older revision		Revision as of 17:46, 9 July 2014
Line 22:		Line 22:
	</pre>		</pre>

	(any change here ~~most~~ be done on the public page too)		(any change here must be done on the public page too)
	{{NavBox Upgrade}}		{{NavBox Upgrade}}
	[[Category:SQL Queries]]		[[Category:SQL Queries]]
	[[Category:NAA]]		[[Category:NAA]]
	[[Category:NoPublic]]		[[Category:NoPublic]]

Alnaucler at 15:44, 9 July 2014

2014-07-09T15:44:46Z

← Older revision		Revision as of 17:44, 9 July 2014
Line 21:		Line 21:
	imsmaenum.enumvalue ASC		imsmaenum.enumvalue ASC
	</pre>		</pre>

			(any change here most be done on the public page too)
	{{NavBox Upgrade}}		{{NavBox Upgrade}}
	[[Category:SQL Queries]]		[[Category:SQL Queries]]
	[[Category:NAA]]		[[Category:NAA]]
	[[Category:NoPublic]]		[[Category:NoPublic]]

Alnaucler at 15:17, 9 July 2014

2014-07-09T15:17:22Z

← Older revision		Revision as of 17:17, 9 July 2014
Line 2:		Line 2:
	{{Note \| The import problem will also occur in cases where one enumvalue is active and the others are inactive. The import problem does not apply to CDFs. }}		{{Note \| The import problem will also occur in cases where one enumvalue is active and the others are inactive. The import problem does not apply to CDFs. }}

	If this SQL gives a result set, ~~contact~~ your ~~GICHD IM advisor~~:		If this SQL gives a result set, your country may had a undetected problem also during 5.x:
	<pre>		<pre>
	SELECT		SELECT

Alnaucler: Created page with "{{Warning | Duplicate enumvalues will cause import problems that are difficult to detect because there is no error message. }} {{Note | The import problem will also occur in c..."

2014-07-09T15:15:23Z

Created page with "{{Warning | Duplicate enumvalues will cause import problems that are difficult to detect because there is no error message. }} {{Note | The import problem will also occur in c..."

New page

{{Warning | Duplicate enumvalues will cause import problems that are difficult to detect because there is no error message. }}
{{Note | The import problem will also occur in cases where one enumvalue is active and the others are inactive. The import problem does not apply to CDFs. }}

If this SQL gives a result set, contact your GICHD IM advisor:
<pre>
SELECT
imsmaenum.enumcategory,
imsmaenum.enumvalue,
COUNT (imsmaenum.imsmaenum_guid)
FROM
imsmaenum
GROUP BY
imsmaenum.enumcategory,
imsmaenum.enumvalue
HAVING
COUNT (
imsmaenum.imsmaenum_guid
) > 1
ORDER BY
imsmaenum.enumcategory ASC,
imsmaenum.enumvalue ASC
</pre>

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