laptop and a wrench

Bug

SQL queries are not honored by feature-linked annotation classes in a file geodatabase.

Last Published: February 15, 2021 ArcGIS for Desktop
Bug ID Number BUG-000091297
SubmittedOctober 8, 2015
Last ModifiedJune 5, 2024
Applies toArcGIS for Desktop
Version found10.3
Operating SystemN/A
Operating System VersionN/A
StatusWill Not Be Addressed

Additional Information

The feature-linked annotation is working correctly. For new annotation to be created, there must be a new feature created or an existing feature must have its shape changed (vertex edited, split, etc) For existing annotation to change, the feature needs to fit on only one SQL query. If it fits in two SQL queries, the annotation exists in the first one it satisfies.

Workaround

Create label classes in the feature class prior to converting to annotation.

  1. Right-click the layer, click Properties, and click the Label tab.
  2. Change the label method, and create classes.
  3. Apply SQL queries to each class, and make sure ‘Label features in this class’ is checked before converting to annotation. 

Note: By right-clicking the annotation class in the Catalog window > Properties > Annotation classes, each label class turns into an annotation class, and the SQL query applied to the label class is now applied to the annotation class. Changes made to the SQL query here are not honored.

Steps to Reproduce

Bug ID: BUG-000091297

Software:

  • ArcGIS for Desktop

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