Searching a Database with Auto-Complete Search Control

Overview

The AutoComplete Search Form component lets a user enter characters and produces a list of values that match those characters, beginning with a partial match. The data type for the AutoComplete Search component is a string list.

Example

This example uses data from the Account database to populate an Auto Complete Search component. This component can use an external database; for example, purposes use a default database available within Decisions. 

1. In a Flow Designer, in the Toolbox panel, navigate to Integrations. Select Advanced.
2. Expand Internal Services. Select Advanced.
3. Expand AccountService.
4. Select the GetAll step, drag, and drop it into the workspace. Connect the Start step to the GetAll step.
   
   
5. Select the Done outcome path of the GetAll step.
6. In the Add After dialog, select the Show Form step in the Favorite Steps category. Select ADD.
7. With the Show Form step selected, in the Properties panel, select PICK OR CREATE FORM.
8. Select CREATE under Create New. Choose Form, name the Form, and then select CREATE.
   
   
9. The Form is designed with a Button and the Auto Complete Search control located within the Toolbox panel. The Button is named "Submit".
10. Select the Auto CompleteSearch control. In the Properties panel, navigate to List Data. Name List Items Data Name: "Accounts"
11. Save and close the Form Designer.
    
    
12. In the Flow Designer, select the Show Form step.
13. Under Inputs > Accounts, select Pick. In the Pick Data for Input dialog, choose GetAll1_Output.
14. Connect the path from the Show Form step to the End step.

Debug

1. Select Debug on the top panel of the Flow Designer.
2. When the Flow runs, begin typing in the search component to see matching accounts.