2022.2

Alternate syntax(not recommended): Select to prevent PlanetPress Design from automatically
enclosing the names of any database tables and fields that appear in the SQL query in square
brackets when it exits the advanced SQL Statement dialog box.
6. Client side cursor: Select to download result sets to client computer running the SQL query.
Under some circumstances, client side cursors may be slightly less efficient than server-side
cursors, but they may also provide additional functionality, depending on the type of query that is
issued.
7. Click OK to return to the Database Connection dialog box.
Opening a previously used data file
PReS Workflow also keeps the last 9 used data files in memory, which you can reopen to use in the
same process, or in a different one.
To reopen a sample data file:
1. Click the Debug tab in the PReS Workflow Ribbon.
2. Click on Reopen Data File in the Data group.
3. Click on one of the data files in the list.
4. Use the Data Selector to change the emulation options if necessary.
5. Click OK on the Data Selector.
Metadata
Metadata is a hierarchical structure describing a job. Simply put, Metadata is data about data or, in
other words, information tagged to data. Depending on the type of job, the Metadata includes inform-
ation about the job, the data file, items in the Connect database, a PlanetPress Design document, 'User
defined information' (sometimes created by regular tasks) and in some cases page properties and page
counts.
Some of the Action and Output tasks produce, alter, or use the Metadata. In addition to that, PReS
Workflow provides a whole series of plugins to create and edit Metadata during a Workflow process
(see "Metadata tasks" on page467). The things that you have to know in order to use the Metadata
tasks effectively are set out in another topic: "Working with Metadata" on page69.
You can also manipulate the Metadata in your process via scripts using the Metadata API. See
Metadata API Reference.
Note: Applications or plugins created in PlanetPress Suite 6 and using Metadata will need to be
updated for use in version 2022.2. No backward compatibility mode is available.
Page 66