Defining Queries for a Specifications Catalog

This task shows you how to define queries for a specifications catalog.
A specifications catalog allows you to specify which parts can be used for a certain project or part of a project. When you create a specifications catalog you specify what part types you want to use. When you define a query you refine the search further and specify what properties you want these part types to have.

You must first define directory paths as described in Understanding Project Resource Management.

1. Open the specifications catalog for which you want to define a query.

2. Select the Generative Data tab if it is not selected. You will see two windows, Generated Definitions and Generated Components.
3. Select the part type (double click) for which you want to define a query and click the Add Catalog Resolved Filter Components button. The Resolved Filter Definition dialog box will display.

4. Enter a query name in the Name field if you want to change the default name.
5. In the Filtered Catalog field enter the path to the main catalog from which you want to search for parts ( or browse to it).
6. Click the Filter button. The Filter dialog box will display. NOTE: You can also enter the query parameters directly in this field. The query syntax is defined in Knowledgeware documentation.

7. Enter the values for the part type. These are the values for which the specifications catalog will search in the main catalog. Depending on how your system administrator has set up the application, some fields may display drop down boxes from which you select a value, rather then entering them in the field.

The first column contains the operators. Some operators are straightforward, such as those under WeighDry, where they mean Greater Than etc.

Some others look like this:

In this case == means String. This means only exact matches will be reported. *= means sub-string. This means that all entries that contain this value will be reported.

Click OK.

Once you click OK your values will display in the Filter field of the Query Definition box. Do not edit these values in this field. It is possible to do so, but only if you follow the exact convention observed. It is safer to change the values in the Filter dialog box.
8. Click OK again in the Query Definition box. Your query will be created and will display in the Generative Definitions window.