Changes

Imsmaenum Duplicate fix

781 bytes added, 23:11, 5 July 2014

Created page with "This query should be exported as documentation of the values of the four affected enum categories: <pre> SELECT DISTINCT "public".imsmaenum.imsmaenum_guid, "public".imsmaenum...."

This query should be exported as documentation of the values of the four affected enum categories:
<pre>
SELECT DISTINCT
"public".imsmaenum.imsmaenum_guid,
"public".imsmaenum.enumcategory,
"public".imsmaenum.enumvalue,
"public".imsmaenum.widgettype,
"public".imsmaenum.seqno,
"public".imsmaenum.dataentrydate,
"public".imsmaenum.dataenterer,
"public".imsmaenum.isactive
FROM
"public".imsmaenum
WHERE
"public".imsmaenum.enumcategory = 'Mine Action Activity' OR
"public".imsmaenum.enumcategory = 'RecommendationType' OR
"public".imsmaenum.enumcategory = 'Worksite' OR
"public".imsmaenum.enumcategory = 'Theme Type'
ORDER BY
"public".imsmaenum.enumcategory ASC,
"public".imsmaenum.enumvalue ASC
</pre>
{{NavBox Upgrade}}
[[Category:NoPublic]]
[[Category:SQL Queries]]
[[Category:NAA]]

• Newer edit →

Alnaucler

NoPublic, bureaucrat, administrator

6,632

edits