6. Filter Log Table Lists

About this task

  • Define filter.
  • Wildcard guidelines.

Define filter

Procedure

  1. Do one of the following in the Database Logger Configuration window or any open table.
    A Click View>Filter... on the Database Logger Configuration window menu bar.
    B Click the Filter button on the Database Logger Configuration window or a table's toolbar.

    A Filter <Type> dialog box opens.

    Where

    <Type> depends on the table or window in which the filter operation is being used.

  2. Enter filter specifications based in the associated dialog box as follows.
    • Database Logger Configuration window.

    A Filter Tables dialog box opens.

    Enter the following.

    Field Description
    Table Identifier Full or partial table ID. Use the ? and * wildcards to perform partial string searches.
    Table Type Options are:
    • ALARM
    • ALL
    • DATA
    • EXTERNAL
    • GROUP
    • Data log or group log table
    • Data log or group log table.

    A Filter Points dialog box opens.

    Enter the following.

    Field Description
    Point Identifier Full or partial point ID. Use the ? and * wildcards to perform partial string searches.
    Point Type Options are:
    • 4STATE
    • ALL
    • ANALOG
    • APPL
    • DIGITAL
    • TEXT
    • ALARM_LOG table and EVENT_LOG tables.

    A Filter Alarms dialog box opens.

    Enter the following.

    Field Description
    Alarm Identifier Full or partial alarm ID. Use the ? and * wildcards to perform partial string searches.
    Alarm Type Not available.
  3. Do one of the following.
    1. Click OK to filter the list according to the information you've entered.
    2. Click Cancel to cancel the filter function.
    Tip: To display all the items in the table, enter an asterisk (*) in the <Type> Identifier field.

    Wildcard guidelines

    You can use the following wild cards in the Database Logger user interface:

    wildcard Description
    * Search for any number of characters at this point in the string.
    ? Search for any single character in this place in the string.
    _ If you are calling ODBC functions directly, you cannot use the * and ? wild cards. The underscore character, _,is the only available wild card. Use it to search for any character in this place in a string.
    Note:
    • There are no implied wild cards.

    If you do not include or terminate your search string with an asterisk, only those items that match your request exactly will be returned.

    • If you are calling SQL functions directly, you can use the * and ? wild cards.