Extra Keys

In the DMP dataset, you can define and name up to six extra keys that only exists in the Dataset Property dialog box.

On the Extra Key section, you can filter and define groups for extra keys. The benefit of extra keys is that you can easily change it in the Grid and use it efficiently for data filtering.

You can define Key Groups and Key Patterns similar to basic keys. See Key Group Setup.

These are examples of returned records with extra keys:

  • NOT [PROMO] AND NULL

    This returns records where the extra key is not exactly PROMO but inclusive of all empty extra key records.

  • NOT [PROMO]

    This returns records where the extra key is not exactly PROMO but exclusive of empty extra key records.

  • NOT NULL

    This returns records where the extra key is not empty.