topic Re: ArcGIS Pro not sorting numeric attributes correctly in ArcGIS Pro Questions

ArcGIS Pro not sorting numeric attributes correctly

LJackson29 — Mon, 27 Dec 2021 14:36:14 GMT

I am encountering issues with ArcGIS Pro (2.8.1) not sorting numeric attributes correctly as shown below when Urgency_CR is sorted ascending (see snapshots 1 and 2 below). When I use the custom sort, and select ascending it sorts correctly. On further investigation, it appears that Pro is sorting on the attribute to the right of the attribute I am trying to sort on. For example in the 3rd snapshot below, I tried to sort on RoadwayElevation Ascending using the drop down and it did not work. When I opened the Custom Sort window it showed the attribute to the right being sorted (I had not previously sorted on that attribute).

I have also had an issue where I was not able to sort an attribute (ascending and descending were shaded out in the dropdown menu), but I was able to sort using custom sort.

Re: ArcGIS Pro not sorting numeric attributes correctly

ABishop — Mon, 27 Dec 2021 18:15:24 GMT

What field type are those fields you are sorting?

Re: ArcGIS Pro not sorting numeric attributes correctly

LJackson29 — Mon, 27 Dec 2021 18:18:22 GMT

Urgency_CR is numeric (long) as shown in the snapshot.

RoadwayElevation is numeric (double).

Re: ArcGIS Pro not sorting numeric attributes correctly

ABishop — Mon, 27 Dec 2021 18:22:55 GMT

Are they shape files or feature classes? If they are feature classes where are they being stored? Database or file geodatabase?

Re: ArcGIS Pro not sorting numeric attributes correctly

LJackson29 — Mon, 27 Dec 2021 18:24:40 GMT

Feature classes stored in a file geodatabase. I am using ArcGIS Pro 2.8.1.

Re: ArcGIS Pro not sorting numeric attributes correctly

ABishop — Mon, 27 Dec 2021 18:31:23 GMT

Try adding an attribute index or global ID.