Configuration Guide

Back Next

Adding a Generic Query

If you want to use the building blocks to construct a query that can be understood by any of the supported databases, add a generic query.

If you want to code an SQL statement, add a custom query instead.

In the

Model

workbench, click

Queries

Acquire a write lock.

Optionally, in the navigation pane, select the query group to which you want to add the query.

Right-click in the navigation pane and click

New Query

The

New Query Wizard

opens.

If you see a

Welcome

screen, click

Specify the general query properties, and click Next
:

Property	Description
Query name	Type a descriptive name for the query.
Description	Optionally, type a description for the query.
Query Group	Optionally, select a different query group.
Select primary table	Select the table from which you want to retrieve data.