laptop and a wrench

Bug

Adding a definition query excludes a row of data when using the Add Join geoprocessing tool in ArcGIS Pro.

ArcGIS Pro
Bug ID Number BUG-000170869
SubmittedSeptember 19, 2024
Last ModifiedJune 2, 2025
Applies toArcGIS Pro
Version found3.3.1
Operating SystemN/A
Operating System VersionN/A
StatusAs Designed

Additional Information

This issue has been documented and has existed since ArcMap. An information banner is provided on the tool dialog announcing the definition query will be applied.

Workaround

Modify the definition query from the input layer:

1. Open the Contents pane > Right-click the input layer and click Properties. 

2. On the Layer Properties window, click the Definition Query tab. 

3. Alter the definition query or disable it by clicking the green check box.

Steps to Reproduce

Bug ID: BUG-000170869

Software:

  • ArcGIS Pro

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