Share this page

# Prerequisites

Before adding a filter field, you must determine the following:

- The name and validation ID of the SQL validation to be used for the new filter field. Validation names are related to work item types as follows:

  - For projects, the validation names end with `Project Work Items.`

  - For tasks, the validation names end with `Task Work Items.`

  - For requests or packages, the validation names end with `Work Item.`

  Table 8-2. SQL validation IDs for filter fields lists the relevant validation names and their validation IDs.

  Table 8-2. SQL validation IDs for filter fields
  Validation Name | Validation ID
  --- | ---
  TMG - Time Sheet Details - Project Work Items | 3079
  TMG - Time Sheet Details - Task Work Items | 2693
  TMG - Time Sheet Details - Work Item | 826

- The SQL to support the new filter field. Knowledge of SQL and database schema is required to write the SQL for the new filter field.

- The name of the new filter field. An example is Creation Date.

- The token for the new filter field. An example is `CREATION_DATE.` (When editing the SQL code in the SQL validation, add the `FLTR` prefix to the token name, as in `FLTR.CREATION_DATE.`)

https://admhelp.microfocus.com PPM 8942
Tips to improve your search results... OpenText™ Project and Portfolio Management Help Center PPM Help 26.2-26.3 All View Local Help Center View Online Help Center Version: