
Queries 95
Creating a Query
To create a query:
1
In the Module Contents pane, click the Queries tab.
2
To create a new query, click Add.
The New Query dialog box appears.
3
To start from an empty query, ensure that the Blank checkbox is selected.
4
Select the data source type from the drop-down list.
5
To close the New Query dialog box and proceed to write the query, click OK.
The New Query dialog box closes, and the Definitions Pane appears in the pane
to the right.
Note An exclamation mark that appears in the Definitions pane next to an input field
indicates that the query cannot be saved unless you set that field. A corresponding
tooltip also displays.
6
In the Name box type a name for the query.
When you are creating the query, save the query. That name appears in the
Queries tab.
7
In the Comments box, type a brief description of the query you are writing.
Alternatively, you can add more information using the Context Help box if
desired.
8
Define the Data Source ID for the Data Source Type.
9
To add the parameter, under Required Parameters, click the plus icon.
A set of input fields appears. You can use them to further define the parameters
that are passed to the query.
10
In the Name box, type the name of your choice—the one that you want to
associate with the object type that is passed as a parameter to the query.
11
Define the object type by clicking Object Type and selecting a type from the list
that appears.
12
Select one of the options in the List box to choose whether it is acceptable for the
returned objects to be a list, not a list, or either.
13
Select an option from the Object Type drop-down list to define the type of
objects that are selected by the query.
14
Ensure that the query searches for all Object Type instances in the collection
model. To do that, verify that a forward slash ‘/’appears in the Root box, under
Root Path. Then click the Browse button to the right of with Path and choose
Komentarze do niniejszej Instrukcji