laptop and a wrench

不具合

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
不具合 ID 番号 BUG-000164016
送信されましたDecember 28, 2023
最終更新日February 18, 2025
適用対象ArcGIS Pro
見つかったバージョン3.1.3
オペレーティング システムWindows OS
オペレーティング システムのバージョン11.0
ステータスAs Designed

参考情報

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.

再現の手順

不具合 ID: BUG-000164016

ソフトウェア:

  • ArcGIS Pro

バグのステータスが変更されたときに通知を受け取る

Esri Support アプリのダウンロード

このトピックについてさらに調べる

ArcGIS エキスパートのサポートを受ける

テクニカル サポートへのお問い合わせ

Esri Support アプリのダウンロード

ダウンロード オプションに移動