Adding Search Conditions
Copy
You can specify Search conditions for every level of the Query Definition Structure. These search conditions can refine the set of data the Query returns. The query logic can include the components shown in Table 2.
Table 1: Query elements
| Comparison Operators | Boolean Operators | Aggregate Functions |
=!=>>=<<=likeis null | ANDORNOT | Count() |
Note
Query Builder does not support comparison of string and integer values. For example, you can use logic like
, but you cannot use
.
Count(…) = 3, but you cannot use
Count(…) = “3".
Use the following process to add Conditions to the Query Definition item:
Right-click the CAD element and click Edit Query Element --> Condition.
Figure 21.
Enter a search condition, such as
[Name] = ‘CAD_1’Na.Figure 22.
NoteConditions written in Query Builder must be separated by white space. For example, you can use the condition Cost >= 0 but not Cost>=0.
- Right-click the Document element and click Edit Query Element --> Condition.
Enter a search condition such as
[Document Number] like ‘A27%'.Figure 23.
NoteBrackets are placed around multi-word properties in the condition window of Query Builder. You may notice that these brackets automatically disappear for single-word properties.
- Right-click the top Part element and click Edit Query Element --> Condition.
Enter a search condition that enforces the CAD and Document Relationships to exist:
(Count([[Relationship]] Part CAD) >= 1) AND (Count([[Relationship]] Part Document) >= 1)Figure 24.
- Save the Query Definition.
