Actions

This section shows the Actions available in the Selection Criterion Specification workspace.

Top Tab

Field	Description
Export Statement	Use this action to create a file with the saved SQL-statements.
Validate	Use this action to validate the selection criterion specification.
Import SQL File	This action is only available for selection criterion specifications where the type specified in the field “Type” is a manually created option. See the field “Type” for further information on manually created options. When you select the action, Maconomy prompts you for a text file containing the SQL expression that makes up the selection criteria of the selection criterion specification. The SQL expression must only contain selection criteria (queries) on fields in the database table indicated by the selection criterion type specified in the field “Type.” The SQL expression is then stored in Maconomy overwriting any previously stored SQL expression and applied whenever the selection criterion specification is used.
Export SQL File	When you select this action, Maconomy exports the SQL expression file that makes up the selection criteria of the selection criterion specification to a text file. Maconomy prompts you for a file name and location in which to store the file. This allows you to edit the SQL expression and re-import it using the action “Import SQL File.”