Query Summary

When the Queries node is selected in the schedule tree, the detail pane displays a summary of all defined database queries.

Query

The system identifier for the query.

Query Description

The query descriptive name.

Query Type

The type of query (SQL, stored procedure, or middleware).

SQL

The first line of the query.

Left-clicking a column heading allows you to sort the query display by that field. Click that heading again to reverse the sort order. Ctrl+click on other headings to add secondary and tertiary sort fields.

The query data in the summary pane is read-only. To modify a query, select the desired query node in the tree and change the desired values.

Database queries are used for exporting data. Many pre-defined queries are included with every MES system. These queries may be used as-is or modified to suit your needs. New queries may be easily added to your system as well.

Right-clicking a query node opens a context menu that contains the following options:

Delete

Deletes the selected query. You will be prompted to confirm the delete.

Where Used

Opens a window listing all import & export schedules in which this query is used.

Refresh All

Updates the entire tree to reflect any changes made in this window or elsewhere.