laptop and a wrench

Bug

Using the 'Select by Attributes' tool filters incorrect results for a view created from a stand-alone table and a feature class using a CAST function.

ArcGIS Pro
Bug-ID-Nummer BUG-000164016
EingereichtDecember 28, 2023
Zuletzt geändertFebruary 18, 2025
Gilt fürArcGIS Pro
Gefunden in Version3.1.3
BetriebssystemWindows OS
Betriebssystemversion11.0
StatusAs Designed

Zusätzliche Informationen

There is a many to many relationship exists between these two tables. ROW_NUMBER() OVER (ORDER BY Objekt_Point.OBJECTID) can't guarantee to assign the same row number to the same row because there are multiple rows with the exact same value in Objekt_point.OBJECTID field after the join is executed. ArcGIS Pro's selection heavily relies on objectids (in this case it is the value from UniktID field) for selection. If these values can't be guaranteed to be same at all time, the selection does not work correctly. A quick solution to this problem is to add an addition field in the order by clause instead to sort rows the same way when values from the first order by field is same. Here is what can be used ROW_NUMBER() OVER (ORDER BY Objekt_Point.OBJECTID, PM_ErrandRows.OBJECTID) to assign the same row number to the same row at all time.

Schritte zur Reproduzierung

Bug-ID: BUG-000164016

Software:

  • ArcGIS Pro

Benachrichtigung erhalten, wenn sich der Status eines Bugs ändert

Esri Support App herunterladen

Weitere Informationen zu diesem Thema erkunden

Esri Community

Nach zugehörigen Informationen suchen

Training

Nach Schulungen zu diesem Thema suchen

ArcGIS Ideas

Ideen erkunden und Feedback geben

Unterstützung durch ArcGIS-Experten anfordern

An den technischen Support wenden

Esri Support App herunterladen

Zu Download-Optionen wechseln