Performing a Query
Selecting Search Criteria for Samples and/or Sequences

A Query allows you to search for samples and sequences, using a variety of sample or sequence properties. Enter the search criteria (see table) on the Query Wizard: Sequences and/or Samples pages. To further restrict the query, select the SQL tab page of the New Query Properties dialog box. This dialog box is opened automatically after you have clicked Finish. (You can also use this dialog box to edit an existing query. To reopen the dialog box (then called Properties of Query "xyz"), select the query in the Browser, and then select Properties on the context menu.) Click Edit/Insert to open the Edit Conditions dialog box. Select the criteria from the Field list box.

 

Name

Search Parameter

Sample Name

Name

Sample Number

No.

Sample Type

Type

Sample Status

Status

Sample Comment

Comment

Sample Replicate ID

Replicate ID

Sample Inject Volume

Inj. Vol.

Sample Inject Time

Inj. Date/Time

Sample Dilution Factor

Dil. Factor

Sample Weight

Weight (Sample Weight Factor)

Sample Amount

ISTD Amount

Sample Raw Data ID

Chromeleon sample ID.

Sample ID

Sample ID assigned by the user

Sample Program Name

Program used for sample processing

Sample Quantification Method

Method used for sample evaluation

Sample Standard Addition Group

Standard Addition group for assigning Spiked Samples to unspiked unknown samples (see Std. Add. Group)

Sample Reference Amount Set

Reference amount ID for assigning standards, Validiation Samples and/or spiked samples (see Ref. Amount Set)

Sample Auto Purification Type

Autopurification type (also, see Auto Purif. Type)

Sample Auto Purification Reference

Autopurification ID assigned by Chromeleon (see Auto Purif. Ref)

Sample Auto Purification Fraction

Fraction ID assigned by Chromeleon (see Auto Purif. Frac)

Sample Tray

 

Sample GUID

Globally unique sample ID (GUID)

*Sample x

User-defined Column (column name)

Sequence Name

 

Sequence Title

Sequence

Sequence Preferred Channel

 

Sequence Preferred Report

 

Sequence Directory

 

Sequence Timebase

Timebase

Sequence Creation Date

 

Sequence Creation Operator

 

Sequence Last Update

 

Sequence Last Update Operator

 

Sequence Sign Status

 

Sequence Authorized Submit Users

Users authorized to submit the signed sequence

Sequence Submit User

User who submitted the signed sequence

Sequence Submit Date

Date when the signed sequence was submitted.

Sequence Authorized Review Users

Users authorized to review the signed sequence.

Sequence Review User

User who reviewed the signed sequence.

Sequence Review Date

Date when the signed sequence was reviewed.

Sequence Authorized Approved Users

Users authorized to approve the signed sequence.

Sequence Approve User

User who approved the signed sequence

Sequence Approve Date

Date when the signed sequence was approved

 

There are four different groups of search criteria:

1. Text variables, such as, Sample or Sequence Name, Sample ID, etc.

2. Numerical variables, such as, Sample Number, etc.

3. Variables with specific values, such as, Sample Type or Sample Status, etc.

4. Time variables, such as, Sample Inject Time, Sequence Creation Date, etc.

 

These search parameters must be further specified. Different operators are available to link the search criterion with a comparative value. The search criterion determines which operators are available:

 

Operator

Searches all samples...

Available for group no.

=

whose property is identical to the specified character string.

1, 2, 3, 4

< >

whose property is not identical to the specified character string.

1, 2, 3, 4

>

whose property is larger than the specified character string.

1, 2, 4

<

whose property is smaller than the specified character string.

1, 2, 4

>=

whose property is larger than or equal to the specified character string.

1, 2, 4

<=

whose property is smaller than or equal to the specified character string.

1, 2, 4

contains

whose property contains the specified character string.

1

contains not

whose property does not contain the specified character string.

1

starts with

whose property starts with the specified character string.

1

does not start with

whose property does not start with the specified character string.

1

ends with

whose property ends with the specified character string.

1

does not end with

whose property does not end with the specified character string.

1

is like

whose property fulfills the specified wildcard condition.

1

is not like

whose property does not fulfill the specified wildcard condition.

1

is between

whose property is between two values.

1, 2, 4

is not between

whose property is not between two values.

1, 2, 4

during the previous

whose property was created during a specified time before the query.

4

is null

in which the variable does not exist.

1, 2, 3, 4

is not null

in which the variable exists.

1, 2, 3, 4

 

If the operators >, <, >=, or <= are used for text variables, the alphabetical order is considered; for example: A<B.

 Note:

All SQL-time queries containing a relative reference (= during the previous operator) are recalculated for each query.

Wildcards represent character strings. The following wildcards can be used for text variables when the operator is either "is like" or "is (not) like":

 

Wildcard

Description

%

Represents any character string with 0 or more characters.

_(underscore)

Represents any single character.

[ ]

Represents a single character in a specified range; for example, [a-f].

[^]

Represents any character except the specified range.

 

When you have completed your entries, click Apply to start the query.

To restrict the query further, you can enter the restrictions on the Result Restrictions page of the Query Wizard. Else, you can select the Result Restrictions tab page of the New Query Properties (or Properties of Query "xyz") dialog box. Click Edit/Insert to open the Edit Conditions dialog box. Click the "…" button to open the Edit Result Formula dialog box and select a report variable (see Report Categories). The available logical operations depend on the selected sample and sequence properties.

 Note:

Depending on the number of samples resulting from the SQL query, a result-type query may take some time. After approximately 3 seconds, a window is opened indicating the status of the result-type query (in percent of the samples to be tested). The user can use this window to stop the query. In this case, the result of the query includes only those samples of the SQL query that have passed the result test until then.

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