laptop and a wrench

Erro

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
Número de ID do Erro BUG-000164016
EnviadoDecember 28, 2023
Última ModificaçãoFebruary 18, 2025
Aplica-se àArcGIS Pro
Versão encontrada3.1.3
Sistema OperacionalWindows OS
Versão do Sistema Operacional11.0
StatusAs Designed

Informações Adicionais

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.

Etapas para Reproduzir

ID do Erro: BUG-000164016

Software:

  • ArcGIS Pro

Seja notificado quando o status de um erro mudar

Baixe o Aplicativo de Suporte da Esri

Descubra mais sobre este tema

Esri Community

Procurar por informações relacionadas

Training

Encontre treinamento relacionado a este tópico

ArcGIS Ideas

Explore idéias e forneça comentários

Obtenha ajuda de especialistas do ArcGIS

Entre em contato com Suporte Técnico

Baixe o Aplicativo de Suporte da Esri

Ir para as opções de download