Criteria tab options

Use the Criteria tab to specify the filtering criteria for the data value(s) to be returned.

To configure criteria to retrieve data values (narrow format)

1. To configure criteria for a discrete tag, select the first Value check box and set the criteria to be either a 1 or a 0, then go to Step 4.

2. To configure criteria for an analog tag

   • Select the first Value check box and set the criteria for the data value. For example, the value must be greater than ( > ) 1500.

   • (Optional) Select the second Value check box and set another criteria for the data value. For example, the value must be less than ( < ) 2000.

   • Go to Step 4.

3. To configure criteria for a string tag:

   Note: If you use a string criterion, you can only retrieve data for string tags in the query. No data is returned for tags of other types that you may have selected.

   • Select the Use StringHistory check box.

   • Select the third Value check box and specify text that the returned string value must match. You can specify whether the returned value must equal, start, end, or contain the specified text. For example, you can specify that the value must contain the text “alert.”

   • Go to Step 4.

4. (Optional) Select the Value not null check box to filter out null values from the results.

5. (Optional) In the Quality list, click the quality criteria for the data. Only data values that match the quality you specify (Good, Bad, or Doubtful) are returned.

6. (Optional) In the Criteria applicability list, select the moment at which the edge detection criteria is met.

   • first true: Returns only rows that are the first to successfully meet the criteria (return true) after a row did not successfully meet the criteria (returned false). This is also known as “leading” edge detection.

   • no longer true: Returns only rows that are the first to fail the criteria (return false) after a row successfully met the criteria (returned true). This is also known as “trailing” edge detection.

   • true: Returns all rows that successfully meet the criteria; no edge detection is implemented at the specified resolution.

   • first true or are no longer true: All rows satisfying both the leading and trailing conditions are returned.

To configure criteria to retrieve data values (wide format)

7. To filter out null values from the results, select the first checkbox, then click to select a tag.

8. To configure criteria for an analog tag

   • Select the second checkbox, then click to select a tag. Set the criteria for the data value. For example, the value must be greater than ( > ) 50.

   • (Optional) Select the second check box, then click to select a tag. Set another criteria for the data value. For example, the value must be less than ( < ) 20.

9. (Optional) In the Criteria applicability list, select the moment at which the edge detection criteria is met.

   • first true: Returns only rows that are the first to successfully meet the criteria (return true) after a row did not successfully meet the criteria (returned false). This is also known as “leading” edge detection.

   • no longer true: Returns only rows that are the first to fail the criteria (return false) after a row successfully met the criteria (returned true). This is also known as “trailing” edge detection.

   • true: Returns all rows that successfully meet the criteria; no edge detection is implemented at the specified resolution.

   • first true or are no longer true: All rows satisfying both the leading and trailing conditions are returned.