Block: Table (SQL)

After you have connected to a database, you can use that connection to display supplementary information inside workflows.

To use a database in your workflow, start with Customizing the Layout of a Task. In Edit Layout, drag a Table Block from the left menu into to your layout.

Click on your newly created table block to focus the block. On the left menu, under Data, choose Database query from the Type dropdown. Then you can choose the the database you created under Source

Click Edit SQL to open a modal that will allow you to type in your query.

Filtering queries using task data

When writing your SQL queries, you can interpolate data from your task similar to Action Steps. Start by typing {{ and that will reveal a dropdown with the available fields to select from.

If you need to write a query that includes wildcards, you can insert those within the curly brackets