Community
Select to view content in your preferred language

Definition Query Bug

3416
12
02-05-2020 09:38 AM
BrianKaplan
by
Frequent Contributor
‎02-05-2020 09:38 AM

I'm using ArcGIS Pro 2.4.3

I'm using the interactive Definition Query window as shown in the attached.

'Congo, Dem Rep of the' is not added correctly to the SQL string.

Below is the result in the SQL window  The interactive window is incorrectly parsing 'Congo, Dem Rep of the' into two pieces.  

COUNTRY_NA IN ('Angola', 'Congo', 'Dem Rep of the', 'Malawi', 'Tanzania', 'Zimbabwe', 'Mozambique', 'Congo', 'Dem Rep of the', 'Botswana', 'Namibia')

 These data are from the US Department of State. http://geonode.state.gov/layers/geonode%3AGlobal_LSIB_Polygons_Detailed

Preview file
50 KB
12 Replies
Pål_Herman_Sund
by
Frequent Contributor
‎03-15-2020 03:36 AM

The latter bug (000119957) says fixed in 2.6. So my surprise was more "why not in upcoming servicepacks".

0 Kudos
KoryKramer
by Esri Community Moderator
Esri Community Moderator
‎03-16-2020 05:46 AM

It looks like it is being evaluated for inclusion in a 2.5 Patch 1.  

JoshuaBixby
by MVP Esteemed Contributor
MVP Esteemed Contributor
‎03-16-2020 07:46 AM

I am closing this question out as "Assumed Answered."  I realize the bug hasn't been fixed yet, but the answer to the OP's question is, "it is a bug and Esri is working on addressing it."  Kory Kramer‌, please keep posting updates on defect status so people that find this thread in the future has the latest information.