Key Group Setup

Configuring Favorite views involves defining a filter for Basic Keys and Extra Keys.

You can define a Key Group to allow more than one key value to be filtered. You can also define a Key Group using a pattern. Select the Key Pattern option to specify a pattern.

A Key Pattern can have these options:

  • Operations: You can use NOT, AND, and OR.
  • Operands: This is the Key value or part of the Key value.
  • Accept: You can use parentheses ( ) for control of logic and brackets [ ] for special characters in a Key value.
These are some examples of patterns:
  • *A1* AND NOT B*

    This becomes part of the WHERE query:

    K1 LIKE '%A1%' AND K1 NOT LIKE 'B%'

  • C2

    DMP always creates LIKE queries:

    WHERE K1 LIKE 'C2%'

  • *A1* AND ( NOT B* OR NOT C)

    WHERE (K1 LIKE '%A1%' AND ( K1 NOT LIKE 'B%' OR K1 NOT LIKE 'C%') )

  • Special cases [?a('-']

    WHERE ( K1 LIKE '?a(''-''%' )

    You must be specific or include these special signs in your like string: asterisk (*), apostrophe ('), percent (%), question mark (?), or similar. In this case, brackets ([]) are used. 

  • Not ['']

    This means not empty.

  • Not [''] AND [201403[!13]]

    This means not empty and any values starting with 201403 followed by any characters except 1 or 3.

Follow these steps to define filters for key groups or key patterns:

  1. On Favorite View Properties, select Basic Keys or Extra Keys.
  2. On Key Filter, click the ellipsis button.
    The Group Setup dialog box is displayed.
  3. Select Key Group or Key Pattern.
  4. Specify this information:
    Key Groups
    Group Name
    Specify the name of the key group.
    Available Groups
    If applicable, select an option from the list.
    Key Values
    Select an option from the list. You can use the Search field to find a key value.
  5. Click Insert.
  6. Optionally, you can Change or Delete an existing key group or key pattern.
  7. Click Close.