### Creating New Trace Field Queries

1. Double-click on a part to access it.

2. From the Queries list, click the Queries icon. The Queries dialog box appears.

3. Click the New... button. An input box will appear.

4. Type the name for the query and click OK.

5. Now, back at the Queries dialog box, you will work from left to right on the first row, and then top to bottom to define your search criteria.

- Choose a trace name from the Trace Name list. So, if you wanted to look for transactions that were done by the CMM operator named JOE, you would choose the OPERATOR: from the drop down list.

- Choose a mathematical operator from the Operator list. If you wanted an exact match of JOE you would choose the = operator.

- Choose a value from Trace Value 1. Note that these trace values are specific to your current part program. In this case, we'll select JOE.

- If you chose BETWEEN as your operator, Trace Value 2 would become active and you could have it search for trace fields between two values.

- If you want to use multiple clauses, continue to the next row and continue making additional selections. Select the desired Link multiple clauses with option (either the AND or OR option). 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.

Sample query defined to select all records with JOE

- When you're done, click OK to save your changes. The Queries dialog box closes.

Querying Dates: Be aware that DataPage+ requires that you use a date format of YYYY-MM-DD when querying by date (where YYYY is the year, MM is the month, and DD is the day). So, if you were querying for a dates between October 1, 2009 and October 5, 2009, your query Trace Value 1 and 2 fields would use 2009-10-01 and 2009-10-05 respectively. See "About Transactions" for information on the differences in the date format displayed in the Transactions list

6. Select the query from the Queries list in the side bar. DataPage+ will limit the displayed transactions to match your query.

Example query limiting the transactions to show only those with JOE as the operator