Query Tags Tab (Event Tab)

Use the Query Tags tab to configure event queries for the current event.   

Properties on the Query Tags Tab (Event Tab)

Property

Description

Values

Query Tags 1, 2,
and 3

Specifies the data sources to use. The data from the specified data sources are used to determine the event's start and end time. For example, if you want to display data during the manufacture of Lot #5 and Product A12, you would specify two queries: one for the lot number and one for the product number. The resulting data from these queries determines the chart's time criteria.

Ellipsis buttons – use these to launch the Data Source Browser to select a tag from a historical data source.

Caption

The text label for Value fields.

In Run mode, these labels appear at the top of the Event chart above the Value fields. Use the Value fields during Run mode to change the time criteria for the pens associated with the event.

Value

Specifies a value for the current query from a list of available entries. Each selected value has a start time and an end time associated with it. By intersecting the start times and end times of the selected values, the event chart calculates the time span to use when trending data.

For example, suppose you define the following queries:

ID=B100, time span: 8:15 to 9:30   

ID=B101, time span: 9:30 to 10:00   

Lot=M-27, time span: 8:30 to 9:00   

Lot=M-28, time span: 9:00 to 9:30

Using this data, select the values ID=B100 (first query) and Lot=M-27 (second query). The intersection of both time spans determines the time span of the event, in this case 8:30 to 9:00.

Criteria

Allows you to filter out entries from the Value field.

By default, all available values appear in the Value field list. However, you can filter out specific entries using the Criteria field to select a filter and by completing the Expression field with a string value. Refer to Query Filters for a list of possible filters.

Expression

Allows you to enter a string to complete an event query filter.   

Strings are not case-sensitive. Refer to Query Filters for a list of possible filters.

Batch Marked

An indicator that determines when a batch starts.

At Start – the batch is labeled prior to starting.

At End – the batch is labeled after completion.

Clear button

Removes one or more data sources specified in the Query Tag fields.

Click the Clear button for Query Tag 1 to clear all data sources on the tab.

Click the Clear button for Query Tag 2 to clear the data sources for Query Tag 2 and Query Tag 3.

Update button

Updates entries displayed in the Value field to match the specified criteria.

Click the Update button for Query Tag 1 to update all Value field entries on the tab.

Click the Update button for Query Tag 2 to update all Value field entries for Query Tag 2 and 3. For example, if the event time is changed, click the Update button to update the Value combo box with the new values.

Query Filters

This section describes the criteria filters available for query tags.

Query Filters

Criteria

Description

Example

N/A

Indicates no filter is in use.

N/A

=

Displays in the Value field the entry that matches the text in the Expression field.

The filter "=M27" displays the entry M27 in the Value field if that value is available for the selected data source. If the entry is not available, the Value field is blank.

=First

Displays all available entries in the Value field starting with the text in the Expression field.

The filter "=First M27" displays all available entries in the order they occurred starting with M27, such as M27, M28, and M29.    

Data for the Value field are retrieved based on the data's timestamp. For example, if M20 occurs after M29 and M20 is also within the current time span, the server retrieves M27, M28, M29, and M20.

=Last

Displays all available entries in the Value field prior to and including the text in the Expression field.

The filter "=Last M27" displays all available entries prior to and including M27, such as M25, M26, and M27.    

Data for the Value field are retrieved based on the data's timestamp. For example, if M29 occurs before M25 and M29 is also within the current time span, the server retrieves M29, M25, M26, and M27.

<>

Displays all entries in the Value field that do not equal the text in the Expression field.   

The filter "<> M27" displays all entries except M27.

<

Displays all entries in the Value field that are less than the text in the Expression field.

The filter "< M27" displays all entries less than M27. If no entries are less than the filter, the Value field is blank.

>

Displays all entries in the Value field that are greater than the text in the Expression field.

The filter ">M27" displays all entries greater than M27. If no entries are greater than the filter, the Value field is blank.

<=

Displays all entries in the Value field that are less than or equal to the text in the Expression field.

Using the filter "<=M27" displays all entries less than or equal to M27, such as M25, M26, and M27. If no entries are less than or equal to the filter, the Value field is blank.       

Data for the Value field are retrieved based on the search string, not the data's timestamp. For example, if M29 occurs before M25 and M29 is also within the current time span, the server retrieves M25, M26, and M27.

>=

Displays all entries in the Value field that are greater than or equal to the text in the Expression field.

The filter ">=M27" displays all entries greater than or equal to M27, such as M27, M28, and M29. If no entries are greater than or equal to the filter, the Value field is blank.     

Data for the Value field are retrieved based on the search string, not the data's timestamp. For example, if M20 occurs after M29 and M20 is also within the current time span, the server retrieves M27, M28, and M29.