Error
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.
| Número de ID del error | BUG-000164016 |
|---|---|
| Enviado | December 28, 2023 |
| Última modificación | February 18, 2025 |
| Relacionado con | ArcGIS Pro |
| Versión encontrada | 3.1.3 |
| Sistema operativo | Windows OS |
| Versión de sistema operativo | 11.0 |
| Estado | As Designed |
Información adicional
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.Pasos para reproducir
ID del error: BUG-000164016
Software:
- ArcGIS Pro
Recibir notificaciones cuando cambie el estado de un error
Descubrir más sobre este tema
Buscar información relacionada
Encontrar formación relacionada con este tema
Explorar ideas y aportar opiniones
Obtener ayuda de expertos en ArcGIS
Descargar la aplicación de soporte de Esri