The Experience Builder Search widget returns unexpected results for numeric data in ArcGIS Online

Description

In ArcGIS Experience Builder, when using a layer with a numeric data type as the search source, the Search widget does not return expected results unless a complete value is entered. When the value entered is incomplete, the Search widget does not return the expected result, as shown the image below.

However, the widget returns the expected result only when the value entered is complete, as shown in the image below.

Cause

This is expected behavior. Unlike string fields, the Search widget does not support returning results for numeric fields if incomplete values are entered. Refer to ArcGIS Experience Builder: Usage notes for more information.

Solution or Workaround

Create a new string field and populate the field with the numeric data in ArcGIS Online or ArcGIS Pro.

• Using SQL in ArcGIS Online

Calculations can be performed on hosted feature layers with 'Enable Sync' or 'Keep track of changes to the data' enabled to populate a new string field with values from the existing numeric field. Refer to ArcGIS Online: Manage settings for editing for more information.

1. Log in to ArcGIS Online.
2. Open the item page of the hosted feature layer. Refer to ArcGIS Online: Open the item page for instructions.
3. Add a new string field. Refer to ArcGIS Online: Add a field for instructions.
4. Populate the new string field with the numeric data from the numeric field using SQL. Refer to ArcGIS Online: Calculate values for a field from the item page for instructions. The expression is as follows:

<String_field> = <Numeric_field>

• Using Arcade in ArcGIS Online

Arcade is a scripting language designed for use within ArcGIS, providing advanced calculations, flexibility, and functionality in comparison to SQL. To populate a new string field with values from the existing numeric field using Arcade, refer to FAQ: Is it possible to change the field data type created in ArcGIS Online? for instructions.

• Using the Calculate Field tool in ArcGIS Pro

The Calculate Field tool in ArcGIS Pro offers more capabilities as it provides various expression types, such as Python, VBScript, SQL, and Arcade, allowing for more flexibility while transferring the numeric data to a new string field. Refer to the Use the Calculate Field tool section in How To: Change the data type of an existing field in ArcGIS Pro for instructions.

When using the string field as the search source, the expected results are returned even when an incomplete value is entered, as shown in the image below.