### About Trace Field Queries

Trace fields consist of data input by the part program's programmer during creation of the part program, or by an operator during a program's execution. Some common uses for trace fields are to send to the database the operator's name, the CMM used, and so forth.

In Datapage+ you can create and use trace field queries. A query is basically a statement that tells the database to look at the search criteria provided and to return any information that falls within that criteria. So, for example, if you wanted to select all transactions where operator JOE was using CMM B, you could easily do this using a trace field query.

In the side bar, beneath the Transactions list, you will find the Queries list.

Queries list

The Queries icon displays the Queries dialog box. You can use this dialog box to create, delete, or edit queries.

Queries dialog box

- Query Name - This lists all the queries for the current part.

- New - Lets you create a new query name.

- Rename - Renames the selected query.

- Delete - Deletes the selected query.

- Link multiple clauses with - Uses either the logical AND or OR operators to link multiple rows (or clauses) together. Using AND will select data that meets all of the query clauses you enter. Using OR selects data that meets at least one of the clauses you enter.

- Trace Name - This list contains all the trace field names.

- Operator - This list contains comparative and other operators you can use in the query. See "Understanding Query Operators".

- Trace Value 1 - This list contains values stored in the database for the name selected in Trace Name. You can also press DELETE and type your own value here.

- Trace Value 2 - As Trace Value 1, this secondary list only becomes active if the BETWEEN operator is used in the Operator list. You can also press DELETE and type your own value here.

- Red X - This deletes the current row or clause.

- The drop down arrow in the Queries list displays all the available queries.

The following topics provide you with in-depth instructions for working with trace fields.

- Creating New Trace Field Queries

- Editing Trace Field Queries

- Deleting Trace Field Queries

- Understanding Query Operators