topic Re: ArcGIS Pro 2.7.2: “sort ascending\descending” tools are deemed for fields that comes from the joined table, in ArcGIS Pro Questions

ArcGIS Pro 2.7.2: “sort ascending\descending” tools are deemed for fields that comes from the joined table,

JamalNUMAN — Wed, 07 Apr 2021 19:06:12 GMT

ArcGIS Pro 2.7.2: “sort ascending\descending” tools are deemed for fields that comes from the joined table,

I couldn’t figure out why “sort ascending\descending” tools are deemed for fields that come from the joined table (linked with add join tool).

In the screenshot below, a layer (L1) is joined with a table (T1). The “sort ascending\descending” tools fail to work for fields that belong to the joined table (T1)

Is this by design?

Re: ArcGIS Pro 2.7.2: “sort ascending\descending” tools are deemed for fields that comes from the joined table,

Robert_LeClair — Wed, 07 Apr 2021 19:14:37 GMT

Hi Jamal - the only thing I've seen on the internals is a user had this exact same behavior in a project. They created a new project, did the Join and the ascending/descending was not grayed out in the joined table. Try this - what is the result? Please advise.

Re: ArcGIS Pro 2.7.2: “sort ascending\descending” tools are deemed for fields that comes from the joined table,

JamalNUMAN — Thu, 08 Apr 2021 06:34:03 GMT

The data is attached.

After getting the layer and table joined as per the screenshot below, the sorting tools will never work for “Ref_P_table”

Re: ArcGIS Pro 2.7.2: “sort ascending\descending” tools are deemed for fields that comes from the joined table,

Robert_LeClair — Thu, 08 Apr 2021 14:40:20 GMT

Thx for the data Jamal - I think this is a bug based upon my testing.

1. I followed your workflow in a new project and confirmed the sort ascending/sort descending was grayed out - AGP used the "new" Join cardinality of 1:M by default - it seems there's no way to do a traditional 1:1 if the software detects 1:M.

2. Tested in ArcMap where supported cardinalities for a Join are 1:1 and M:1. Sort ascending/sort descending worked.

3. Back in ArcGIS Pro, created a copy of T1 called T2 and removed duplicate records. Create a traditional 1:1 join and sort ascending/sort descending worked.

4. Ran the Join Field GP tool on copies of L1 and T1 - tool modified existing L1 data and used 1:1 cardinality I believe. Sort ascending/sort descending worked.

My belief is that the 1:M cardinality for a Join in ArcGIS Pro 2.7.2 (maybe earlier) is the culprit with the sort ascending/sort descending not working. I recommend you contact Esri Support Services and log this as a BUG.

Let me know if I can provide further assistance. Thx!

Re: ArcGIS Pro 2.7.2: “sort ascending\descending” tools are deemed for fields that comes from the joined table,

JamalNUMAN — Thu, 08 Apr 2021 16:50:30 GMT

Thank you for the feedback.

Is there a section here (community) to report bugs?

Re: ArcGIS Pro 2.7.2: “sort ascending\descending” tools are deemed for fields that comes from the joined table,

Robert_LeClair — Thu, 08 Apr 2021 16:53:34 GMT

Not in the Forum/Topics to my knowledge but you can report a bug here - thx for discovering this!

Re: ArcGIS Pro 2.7.2: “sort ascending\descending” tools are deemed for fields that comes from the joined table,

JeffWard1 — Sat, 14 May 2022 15:39:48 GMT

@Robert_LeClair Any workarounds for this behavior other than starting a new project?

Re: ArcGIS Pro 2.7.2: “sort ascending\descending” tools are deemed for fields that comes from the joined table,

Robert_LeClair — Fri, 20 May 2022 20:51:31 GMT

Jeff - so this has been identified as BUG-00013896 - "In ArcGIS Pro, the options to sort the joined fields in ascending and descending order are not available after performing a 1:M join." It is in the Product Plan to be fixed - not sure when though. Workaround is to refresh the table after the join but I don't see this working in my ArcGIS Pro 2.9.3

Re: ArcGIS Pro 2.7.2: “sort ascending\descending” tools are deemed for fields that comes from the joined table,

JamalNUMAN — Sat, 30 Jul 2022 15:30:48 GMT

Appears to work fine in 2.8.4