Limit results returned by the ArcGIS Experience Builder Query widget when input is blank

Summary

By default, when the input is left blank, clicking Apply in the ArcGIS Experience Builder Query widget returns every feature from the table, which makes identifying relevant results difficult. To address this behavior, the query can be configured to return a single record with no attribute value, preventing all records from being displayed when no input is provided.

This article provides the workflow to limit the results returned by the Query widget in ArcGIS Experience Builder when the input is blank.

Procedure

Add a new feature with no attribute values and sort the field to place the feature as the first record in the table. The Query widget uses the first available feature in the table to display a blank result when the record is counted.

1. In ArcGIS Online, open the web map and add a point feature with no attribute values within the existing feature layer.

2. Save the map.
3. Open the existing ArcGIS Experience Builder web experience. Refresh the web experience, if necessary.
4. On the sidebar of the web experience, click the Data tab.
5. In the Data panel, select the web map card and click the feature layer card.
6. Create a new data view and sort the records.
   1. In the feature layer details pane, on the Data views tab, click + Create a view.
   2. In the Data view window, click Sort > + Add a sort field.
   3. Select the OBJECTID field from the drop-down menu to sort and click the Descending order so the newly created feature is treated as the first feature in the table.

4. Click the Records tab, toggle Maximum on and specify Maximum record count as 1. The output record count is limited to one record, defaulting to the first available feature in the table.

5. Click Apply changes.

7. Click the Query widget on the canvas to open its configuration panel.
8. In the configuration panel, on the Content tab, select the query item.
9. In the Set query panel, under Data, select the newly created data view from the drop-down menu. In this example, Data view 1 is selected.

10. Add a clause through the SQL Expression Builder and configure the clause by creating an expression.
    1. Under Attribute filter, click SQL Expression Builder > + Add clause.
    2. For the field input box, select the field from the drop-down list. In this example, the field EmployeeCount is selected.
    3. For the operator input box, select a functional operator from the drop-down list. In this example, the is operator is selected.
    4. Click Select source type and select User input.
    5. Click More input settings > Ask for values.
    6. Click OK.

11. Navigate to Results and expand the section. For Configure each record, select Customize from the drop-down menu.
12. Under Display fields, deselect the OBJECTID field from the drop-down list.

Note:
The OBJECTID field is automatically added to a table with default values. It is deselected from display to ensure the query result contains no attribute values.

13. Click Save and Publish to publish the experience.

The Query widget shows a single record with no attribute value returned as the query result when Apply is clicked with a blank input.