Editing an SQL Validation

This section details how to edit an existing SQL validation to support the new filter field for the work item.

To edit the SQL validation:

  1. Log on to PPM.

  2. From the menu bar, select Open > Administration > Open Workbench.

    The PPM Workbench opens.

  3. From the shortcut bar, select Configuration > Validations.

    The Validation Workbench opens.

  4. In the Validation Name field, enter TMG and click List.

    The Results tab lists only the validations associated with Time Management.

  5. In the Results tab, select the appropriate validation listed in Table 8-2 in Prerequisites, depending on the section (Section Name) where the new work item filter field was added in step 7 in Adding a New Filter Field to the Work Item Filters.

  6. Click Open.

    The Validation window opens.

  7. Copy the SQL from the SQL field and paste it into an SQL editor.

  8. Edit the SQL as needed.

    Include the new prefixed token, such as FLTR.CREATION_DATE. The prefixed token should be added to the WHERE clause of the validation SQL.