Bug
Set definition query to line feature class produced different output depending on the data sources either from local drive or ArcGIS Online.
| Bug ID Number | BUG-000138058 |
|---|---|
| Submitted | March 10, 2021 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS Pro |
| Version found | 2.7 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Will Not Be Addressed |
Additional Information
Different databases have different settings and implementations for LIKE. Use a where clause like "UPPER(status) LIKE '%EXISTING%'" to get consistent results across all databases.Workaround
- Add another two clauses by clicking on the Add Clause button in the Definition Query column.
- Change the third box as “existing” and “EXISTING”.
- Click Apply > OK.
Notice the attribute is filtering and all the 9 lines finally show up and all are selectable.
Steps to Reproduce
Bug ID: BUG-000138058
Software:
- ArcGIS Pro
Get notified when the status of a bug changes
Discover more on this topic
Search for related information
Find training related to this topic
Explore ideas and give feedback
Get help from ArcGIS experts
Download the Esri Support App