laptop and a wrench

Bug

The query layer with a WHERE clause does not show the full query in diagnostic monitor.

ArcGIS Pro
Bug ID Number BUG-000167373
SubmittedMay 9, 2024
Last ModifiedMay 27, 2026
Applies toArcGIS Pro
Version found3.2.2
Operating SystemWindows OS
Operating System Version10.0
StatusNon-Reproducible

Additional Information

Database: DatabaseNameHere Version: sde.DEFAULT SQL: SELECT OBJECTID,ESMT_ID,TYPE,RE_NUM,DEEDNUM,BOOK_PAGE,RECORDED,OWNER,GIS_AREA,DESCRIPT,DEED_LINK,GLOBALID FROM (select OBJECTID,ESMT_ID,TYPE,RE_NUM,DEEDNUM,BOOK_PAGE,RECORDED,OWNER,GIS_AREA,DESCRIPT,DEED_LINK,GLOBALID,SHAPE,GDB_GEOMATTR_DATA from sde.cd_view WHERE OBJECTID > 4) a WHERE OBJECTID IN ( 4994853, 4994888, 4994900, 4994922, 4994928, 4994986, 4994997, 4995010, 4995033, ... 4999124 ) Number of rows returned: 200 The QueryLayer now includes the full user where clause in the diagnostic monitor. Note: Draw queries - refer to it simply as the layer name (or %querylayer name).

Steps to Reproduce

Bug ID: BUG-000167373

Software:

  • ArcGIS Pro

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options