SQL Table Editor Searchable Drop-Down List

When drop-down lists have many items to choose from, finding a suitable item in the list can be cumbersome. You can make the drop-down list searchable to improve the efficiency of finding the appropriate item. As you type, search options are narrowed down to those that contain the typed text and you no longer have to scroll through a long list.

NOTE: To use this search feature, the table editor must be configured so that you can edit existing data or add new rows. Columns must be configured with a parameter of type Delimited List, Member List, or Bound List, which is what configures a column as a standard drop-down list.

Enable the Search

1. From the Application tab, select Dashboards, and expand the appropriate Workspace, Maintenance Unit, and Component until you reach the SQL Table Editor component you want to modify.

2. Select the SQL Table Editor to view its properties.

3. Enable the search feature.

   • For all columns that are configured with a list parameter:

     1. In the SQL Table Editor section, set Default for Show Search to TRUE.

     2. Click Save.

   • For specific columns only:

     1. In the SQL Table Editor Column Format section, locate the column where you want to enable the search feature and click the ellipses (...).

     2. In the dialog box, set the ShowSearch property to TRUE.

     3. Click OK.

     4. Click Save.

Use the Search

1. Run the dashboard that contains the SQL Table Editor component.

2. Double-click in a cell to expand the drop-down menu.

3. Start typing in the search field. The drop-down list narrows down to items that contain the typed text.