nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Definition Query Bug

BrianKaplan

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

ArcGISProDefQuery.JPG

Finde mehr Beiträge mit dem Tag

Accepted answers

All comments

bixb0012

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.

KoryKramer

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

pal.herman.sund@geodata.no_Geodata

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

DanPatterson_Retired

BUG-000128909: When using 'includes the value(s)' or 'does not incl..

Strange, it says "not in current production plan"

but its 'duplicate' says Fixed in 2.6

BUG-000119957: In ArcGIS Pro, when using the Includes the value(s) ..

AndySiegel

Hi Luba. Thanks for the response. What's an example of workaround using different delimiters, in the case mentioned by the OP?

Expected result:

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

Actual result:

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

Anonymous User

Hi Andy, it doesn't look like this bug is supposed to be fixed in 2.5. There is a workaround, using delimiters other than commas.

AndySiegel

I'm on 2.4.3 and also have this problem. I haven't upgraded to 2.5 yet, but does 2.5 provide the fix?

Anonymous User

Hi Brian,

Does this include a comma in the name? I think this might be related to a bug we have logged.

BUG-000111347: The layer definition query with Add Clause and 'Include(s) the value(s)' on a text field with comma-separated single values is interpreted incorrectly and separates one value in the data into two separate values.

Nimm an der Unterhaltung teil

Angemeldete Mitglieder können Beiträge verfassen, Updates folgen und mehr. Neu hier? Registriere ein kostenloses Konto.

Schnellzugriffe

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.