To utilize Schema definitions within workflows you may wish to define queries to access data. Queries provide an easy way to load and save data from within a data store in a workflow scenario.
To define and edit queries select a schema definition and click on "Query Editor" in the Schema Context Tab. The appearing dialog allows you to
- Create a new Query or select an existing one
- Select the columns of your result set
These columns will be retrieved from or stored/updated to the database when utilizing the query definition
- Select the columns of your query set
These column(s) are used to identify the rows which will be retrieved or saved from/to the database. Usually you specify the primary key columns here.