Duplicate Enumvalue - Revision history

Alnaucler at 17:25, 17 June 2017

2017-06-17T17:25:26Z

← Older revision		Revision as of 19:25, 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, contact your [[Information Management Team \| GICHD IM advisor]]:		If this SQL gives a result set, contact your [[Information Management Team \| GICHD IM advisor]]:

Alnaucler at 19:00, 29 September 2015

2015-09-29T19:00:50Z

← Older revision		Revision as of 21:00, 29 September 2015
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 [[Management ~~Consulting~~ Team \| GICHD IM advisor]]:		If this SQL gives a result set, contact your [[Information Management Team \| GICHD IM advisor]]:
	<pre>		<pre>
	SELECT		SELECT

Alnaucler at 09:18, 6 November 2014

2014-11-06T09:18:14Z

← Older revision		Revision as of 11:18, 6 November 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, contact your [[Management Consulting Team \| GICHD IM advisor]]:
	<pre>		<pre>
	SELECT		SELECT

Alnaucler at 10:13, 13 July 2014

2014-07-13T10:13:37Z

← Older revision		Revision as of 12:13, 13 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 08:29, 7 July 2014

2014-07-07T08:29:22Z

← Older revision		Revision as of 10:29, 7 July 2014
Line 25:		Line 25:
	[[Category:SQL Queries]]		[[Category:SQL Queries]]
	[[Category:NAA]]		[[Category:NAA]]
			[[Category:Known Issues]]

Alnaucler at 20:11, 5 July 2014

2014-07-05T20:11:49Z

@@ 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. }}
 {{NavBox Technical Notes}}
+[[Category:SQL Queries]]
 [[Category:NAA]]

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-05T20:07:27Z

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

{{NavBox Technical Notes}}

[[Category:NAA]]