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.)