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:
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.
|
|
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.
