laptop and a wrench

Bug

In ArcGIS Pro, using 'contains [the text]' in an SQL expression on the Select By Attributes tool dialog box on a feature service layer based on certain attributes, the selection fails and returns an error message, "ERROR 000358: Invalid expression." although the queried records exist in the attribute table.

Last Published: March 14, 2023 ArcGIS Pro
Bug ID Number BUG-000156492
SubmittedMarch 10, 2023
Last ModifiedJune 5, 2024
Applies toArcGIS Pro
Version found2.9.5
Operating SystemWindows OS
Operating System Version10.0 64 Bit
StatusNon-Reproducible

Additional Information

This issue is not reproducible in the latest version of ArcGIS Pro. If the issue persists, contact Esri Support Services.

Workaround

Add a dash (-) to the query attribute field in the SQL expression on the Select By Attributes tool dialog box.

Steps to Reproduce

Bug ID: BUG-000156492

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