Adding a Query to a Database

Overview

Decisions allows users to add a query to an existing Database Connection during the Database Integration setup or after set up by using the functions found in the System > Integrations > Databases folder; utilizing any of these folder actions like adding Queries, Procedures, Tables, and Views to a Database creates Flow steps for use in the Flow Designer. This method for retrieving data from the database is often used to speed up load times for large data collections.

Example

1. To demonstrate this process of adding a query, the LOCAL CONNECTION database will be used due to it being on all Decisions instances. 
2. Navigate to the integrated database under System > Integrations > Database. Right-click LOCAL CONNECTION and select Add Query.
   
3. Enter a name for the query, representing its purpose (the name cannot contain spaces).
4. In the Query field, add the query. If the query returns data, check the Returns Data checkbox. It is not necessary to add a semicolon to the end of the query.
5. If a count attribute of the result set is desired, click the Output Count checkbox. 
6. In the Input Parameters section, add Inputs to include on the Step generated from this Query.
7. Select Run Query to test the query. The Results tab shows the data returned (if the query returns data). The Dynamic Type tab shows the data structure of the data returned.
   
   
8. Click OK to save the query. 
9. Now, in the Flow Designer, under the components for the database, a component for running this query will be available.