Please ensure Javascript is enabled for purposes of website accessibility
Powered by Zoomin Software. For more details please contactZoomin

Asset Framework and PI System Explorer (PI Server 2018)

Configure search conditions for attribute values when no template is specified

Configure search conditions for attribute values when no template is specified

  • Last UpdatedDec 20, 2024
  • 2 minute read

Before you configure search conditions, you should be aware of the following:

  • When no template is selected, all attributes are searched, including those used in templates.

  • When no template is selected, wildcard characters should not be used in the Attribute Value field.

  • Unindexed attributes can take a significant amount of time to evaluate, particularly if they are configured with a data reference.

  • You cannot search for attributes with Object or Array value types.

When using a PI AF 2018 or later client and connected to a PI AF 2018 or later server, you can restrict your search based on the value of an attribute, without first having to specify a template. Use the Attribute Value field to configure up to three conditions that the search must match regarding an attribute value.

  1. From the Add Criteria list, select Attribute Value.

  2. In Attribute Value, enter the name of the attribute to retrieve.

  3. Click , and select a mathematical operator from the list.

  4. Enter a value. If the value type is Enumeration Set or Guid, you also need to append as Enumeration_Set or as Guid to the search query displayed in the Enter element criteria field.

    For example, to search for assets with a Health Status attribute value of Error, you would enter the following as the Attribute Value criteria:

    An example of how to construct a search for any assets that have Error assigned as their health status.

    To complete the search query, you would append the name of the Health Status enumeration set to the string already displayed in the Enter element criteria field:

    as 'Health Status'

    The completed search query in the Enter element criteria field would look as follows:

    The Element enter criteria field showing the correct syntax to locate assets with an attribute value of Error.

    Keep in mind the following guidelines when appending to search queries:

    • Append As String or As Numeric whenever the value type of an attribute does not match what the query search value appears to be.

    • For example, if the value type of an attribute were String and the search value were 55 (which looks like a numeric), you would need to append As String to the query.

    • Use uppercase and lowercase combinations when you append to search queries: As String, as string, and as STRING are all equivalents.

    • Use either ' or " to enclose enumeration sets and strings that contain space characters.

Related Links
TitleResults for “How to create a CRG?”Also Available in