laptop and a wrench

Bug

Applying a definition query to a feature class using the Add Clause option adds extra apostrophes before and after any commas that may be present within the attribute values.

Last Published: December 4, 2017 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000108931
SubmittedOctober 19, 2017
Last ModifiedJune 5, 2024
Applies toArcSDE/Enterprise Geodatabase
Version found10.1
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusDuplicate

Workaround

  1. Open the Definition Query tab for the feature class again. Click on the 'SQL' button to manually edit the already applied clause.
  2. Edit the clause and remove the extra apostrophe (‘) which has been added before and after the comma between 'Hawaii, state' and 'Maine, state'.
  3. The clause originally displays: STATE_NAME IN ('Hawaii', 'state', 'Maine', 'state'). Change the SQL query to: STATE_NAME IN ('Hawaii, state', 'Maine, state')
  4. The attribute table refreshes and now displays the two records.

Note: There is another workaround in Step 3:

Change the SQL query from:

PROJECT_NAME IN ('Exmouth (Combined Operational Area)', 'Pluto/Brunello (Combined Operational Area)','Scarborough (Combined Operational Area')

to:

PROJECT_NAME IN ('Exmouth (Combined Operational Area)', 'Pluto/Brunello (Combined Operational Area)','Scarborough (Combined Operational Area)')

 

Steps to Reproduce

Bug ID: BUG-000108931

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options