Sort the 'Coded Values' of Domains in Geodatabase

4677
3
12-05-2013 11:37 AM
MG
by
New Contributor
Does anyone know how to sort the values in the drop-down list in the attribute table of a feature, or to sort the 'Coded Values' of Domains in geodatabase?
0 Kudos
3 Replies
WilliamCraft
MVP Regular Contributor
I believe the domain values are sorted by their code rather than their description.  To change the sort order such that it displays differently within the attribute table's drop-down menu, I believe you would need to refine which codes match up to which descriptions.  This is typically done via ArcCatalog when logged in as an administrator such as the SDE user.  Once connected, right click the geodatabase and then choose Properties.  Select the Domains tab and then select the domain associated with the field in question.  Toward the bottom of the dialog box, I recommend copying and pasting the various descriptions into the appropriate lines that match up with the numeric code.
0 Kudos
RussellBrennan
Esri Contributor
There is a tool available to sort coded value domains named 'Sort Coded Value Domain' it can be used to sort on either the code or the description in either ascending or descending order.

http://resources.arcgis.com/en/help/main/10.2/index.html#//00170000016t000000

0 Kudos
JeffLegato
Occasional Contributor
There is a tool available to sort coded value domains named 'Sort Coded Value Domain' it can be used to sort on either the code or the description in either ascending or descending order.

http://resources.arcgis.com/en/help/main/10.2/index.html#//00170000016t000000



Perfect.  Thanks!

FYI, the tool needs an exclusive schema lock on the domain to work.
0 Kudos