Query Builder Workbench Description

Query Builder Window

The following table defines the operators available within Query Builder:

Option Description
Contains Contains the value you have specified in the query.  For example, the internal item might contain a character after a numeric value, say 1E4. The display in the attribute field would be *1E*
Equals Equals with the value you have specified in the query. For example, if the value is equal to 2 for internal items, the display would be =2.
Begins With Search is made according to the criteria specified with the specified value in the beginning. For example, if the value is beginning with 6 for the internal items, the display in the attribute would be 6*.
Ends With Search is made according to the criteria specified with the specified value in the end. For example, if the value specified ends with 8 for the for the internal items, the display in the attribute would be *8.
Does not contain Search is made excluding the values specified. For example, if the value specified is does not contain Z, the display in the attribute would be !*Z*.
Does not begin with Search is made excluding the values specified in the beginning of the attribute selected. For example, if the value specified does not begin with Q, the display in the attribute would be !Q*
Does not end with Search is made excluding the values at the end of the attribute selected. For example, if the value specified does not end with R, the display in the attribute would be !*R.

The following table defines the fields available within Query Builder:

Fields Description
Operator A quantifier that asserts that there exists at least one value of a variable within the query definition.
Value A numerical quantity that can be determined by calculation or measurement
Combination An ordered sequence of values that are combined in order to complete a query expression.

The following table defines the buttons available within Query Builder:

Button Description
Adds the query to the table.  This field is mandatory in order to apply the query to the search criteria.
Discards the defined query from the list.
Moves the defined query into the selected attribute field of the Standard Search window.
Terminates the query operation and returns you to the Standard Search window.