2018.2

l
Tables: Lists all tables and stored queries in the database.
l
Custom Query: Displays the query that retrieves information from a database. You may
use variables and properties in the query, to make the selection dynamic. See "Using
variables and properties in an SQL query" below.
Each database type has their own version of the SQL query language. To learn how to
build your own query, please refer to your database's user manual.
l
Test Query button : Click to test the custom query to ensure it will retrieve the
appropriate information.
l
Results: Displays the result of the SQL query when clicking on Test Query.
Using variables and properties in an SQL query
When you use variables and properties in an SQL query, the selection will be dynamically
adjusted each time the data mapping configuration is actually used in a Workflow process.
To create a dynamic SQL query:
l
The query must start with =
l
Any variable or property must be enclosed in curly brackets: { ... }. This effectively inserts
a JavaScript statement in the query. Note that all other curly brackets must be escaped
with a backslash.
Inside the brackets you may enter any of the following property fields defined in the
Preprocessor step (see "Fixed Automation Properties" on page282 and "Properties" on
page283):
l
Fixed automation properties. These are retrieved via the
automation
object (see "Objects" on page328), for example
automation.jobInfo.JobInfo9
or
automation.properties.OriginalFilename
.
l
Properties that have their scope set to "Entire data". These are retrieved via the
data
object (see "data" on page335), for example:
data.properties.myProperty
.
l
Properties that have their scope set to "Automation variable". These are retrieved via
automation.variables
Page 278