2022.2

l
You can use dynamic properties (properties that include variables or data available at run-time).
This option lets you create a dynamic database connection string as well as an SQL statement
that changes based on the data processed by PlanetPress Workflow. Note that this option will not
let you test the query performed by this task before it is performed with actual data.
Input
Any data file. The data file will be discarded by the task.
Processing
A connection to the selected database is made, the data is retrieved, and an output in the selected emu-
lation format is generated.
Output
The result of the query is output in the selected data format. The current emulation is changed to the
selected format. Metadata and Job Info variables are not modified in any way.
Job Information definitions
l
%1 - DB Connection String
l
%2 - The actual query used
l
%3 - The number of records returned.
Task properties
Database Connection Tab
l
Database group
l
Location: Enter either the path and name of the database or a database connection string
in this box. You may click to navigate to the database and paste the database path and
name automatically to this box. You may also click create an ODBC connection string to
the data source and paste the string automatically to this box. If a login name and pass-
word are required to connect to the database, a dialog box is displayed and the information
you enter is saved in the configuration of the PlanetPress Workflow Database action
task.
l
Table/Query: Select the table or query containing the information you need as your input
data.
Page 370