Sign in

Adding Search Conditions

March 10, 2026 09:43 AM
1 min read

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
=
!=
>
>=
<
<=
like
is null
AND
OR
NOT
Count()
Note
Query Builder does not support comparison of string and integer values. For example, you can use logic like Count(…) = 3
, but you cannot use Count(…) = “3"
.

Use the following process to add Conditions to the Query Definition item:

  1. Right-click the CAD element and click Edit Query Element --> Condition.

    Figure 21.

  2. Enter a search condition, such as [Name] = ‘CAD_1’Na.

    Figure 22.

    Note
    Conditions written in Query Builder must be separated by white space. For example, you can use the condition Cost >= 0 but not Cost>=0.

  1. Right-click the Document element and click Edit Query Element --> Condition.

  2. Enter a search condition such as [Document Number] like ‘A27%'.

    Figure 23.

    Note
    Brackets 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.

  1. Right-click the top Part element and click Edit Query Element --> Condition.

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

  3. Save the Query Definition.