Share this page

# Edit 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. Click the Administration button in the masthead.

2. From the Administration menu, click Workbench > Open Workbench on Desktop.

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.

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: