Adding a Query to External Database

Overview

Decisions allows users to add a query to an existing Database Connection during the Database Integration set up, or after set up by using the functions found in the '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 most often used to speed up load times for large collections of data.

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 > Databases. 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. If there is a need to limit the number of records returned, click the Limit Data checkbox and set the number of records.
6. Click on RUN QUERY to test the query. 
7. The Results tab appears showing 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.