Add ability to search in the table in Manager

[azizaparveen]

Describe requirements

We would like to add the ability to search for records in the table in Manager. Since this is predominantly table focused app and map can be hidden in some workflows, we would like the search in the table to be independent of the map search and will not require any configuration. This search will be dependent on the full text indexing of the layer or table, Full text indexing can be created from feature layer item details /Settings/Manage indexes section https://arcgis4localgov2.maps.arcgis.com/home/item.html?id=3a80482f3ce7444d93b01ed8de682482#settings

• [ ] The search bar will show up only when full text indexing is available on the layer or table

• [ ] Manager will check if supportsFullTextSearch is true in the layer or table

• [ ] Search will be only on the fields that have the full text index. Sample feature layer https://arcgis4localgov2.maps.arcgis.com/home/item.html?id=3a80482f3ce7444d93b01ed8de682482, the RecreationSitesINFRA layer has full text index calculated

Alternatives

No response

Other Relevant Info

No response

Impact

No response

[azizaparveen]

cc @sarahmcdonald7

[azizaparveen]

@sumitzarkar we would like the search box to be in second row when full text indexing is available.

[azizaparveen]

@sumitzarkar as discussed this morning, here is the design doc for the full text search and added some additional detail for this feature.

• [ ] We do not want to show any suggestions.
• [ ] Should have clear search button, when clicked search text will be cleared and it will show all records in table and map.
• [ ] After search is complete, table and map should show only the results that meet the search criteria.
• [ ] If no results found, Manager will not show any results in the table or map (like item search in arcgis online).

[azizaparveen]

@sumitzarkar During our morning discussion today, you asked if there is selection, will the search work only within the selection set. I think that should be the case. I was looking into Table widget behavior in this scenario in Experience Builder, it searches within the selection

[sumitzarkar]

@azizaparveen With EXB the features are not filtered on the map, it reflects only in table.

If we would like to reflect the search on the map we have to update the layer's definitionExpression which will clear the selection.

[azizaparveen]

@sumitzarkar , for search bar default hint text could you please add the field aliases of the fields that have full text indexes on. The text would be, for an example "Search text in Site Subtype and Development Status fields". This will provide hint to the users. We have wide search bar and if there are too many fields we can always use... and on click that will expand. This way if any full text indexed field is hidden, users will get the awareness as well and turn their visibility on.

[sumitzarkar]

@azizaparveen

for search bar default hint text could you please add the field aliases of the fields that have full text indexes on.

• Yes, we can use the field alias in placeholder text.
• Instead of using and to join multiple fields, it would be better and easier to use the pipe symbol '|'.

• Here are a few examples of how it will look:

  • When only one field

  • When multiple fields

We have a wide search bar and if there are too many fields we can always use...

• Showing ... is the default functionality of the calcite input and will work as expected

and on click that will expand

• This is impossible as we have no control over the placeholder. Instead, we can show complete text on hover of the search input.