Bug
Search by layer with the contains method does not return expected results in Map Viewer and Map Viewer Classic if the map uses a string field with a length greater than 4000 as the search source.
| Bug ID Number | BUG-000155622 |
|---|---|
| Submitted | February 4, 2023 |
| Last Modified | June 5, 2024 |
| Applies to | ArcGIS Online |
| Version found | November 2022 |
| Operating System | Windows OS |
| Operating System Version | 10.0 64 Bit |
| Status | Known Limit |
Additional Information
This is a known limitation with the full-text index building on the backend. An index cannot be built on fields with a length of more than 4000. The change is the search that uses WHERE and starts with a based query because no index exists on the field. If an index exists, it searches the terms that make up the rows with a prefix-based search.Workaround
Remove any fields with a length of more than 4000 from the web maps Search by layer sources.
Alternatively, create a field with a length less than 4000, calculate the attributes from the existing field (that is longer than 4000), and use this new field as the search source for the web map's Search by layer.
Steps to Reproduce
Bug ID: BUG-000155622
Software:
- ArcGIS Online
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