Performing a Query
Entering the Sample Query Using the Wizard

On the first wizard page, determine the Datasource in which the Query is performed. Select either Selected datasource (the name of the currently selected datasource is indicated in brackets) or Fixed datasource, and then select a datasource from the drop-down list.

In addition, determine the Field Type for which the query is performed. Select:

On the Samples and/or Sequences wizard page, click the Data Field input field and select the variable for which you want to perform the query from list. On the Results wizard page, either enter the formula manually or click the "…" button, and then select a formula from the Edit Result Formula dialog box.

 Tip:

On the Results wizard page, you cannot access User-defined Columns directly by clicking the '...' button. For user-defined columns from the sample list of the Browser, select the Samples field type, and then select an entry from the Data Field field on the Samples wizard page. For user-defined columns from the peak table of the QNT Editor, select the Results field type, and then enter the formula directly in the Formula field on the Results wizard page. The syntax of the formula is as follows:

peak_tab.user_x

where x is the name of the user-defined column.

You can also search for samples with specified Audit Trail properties. In this case, enter the formula for the selected Audit Trail variable. For example, to search samples that were recorded at a LampIntensity > 500.000 counts/s, use the formula below:

AUDIT.LampIntensity(0.0,"forward")>500000.

 

Select an operator from the Operator field and enter a value in the Value field. For information about the operators, refer to  Selecting Search Criteria for Samples and/or Sequences.

To connect one search criterion with another search criterion, select a logic connective from the rightmost combo box. The next entry line is enabled only after you selected either AND or OR.

Click Finish to complete the entries. The New Query Properties dialog box is opened. Use this dialog box to specify your query further (see  Specifying the Sample Query Using the Dialog Box).

For examples of how to enter the query using the wizard, refer to  Examples (Wizard).