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:
-
Click the Administration button in the masthead.
-
From the Administration menu, click Workbench > Open Workbench on Desktop.
-
From the shortcut bar, select Configuration > Validations.
The Validation Workbench opens.
-
In the Validation Name field, enter
TMG
and click List.The Results tab lists only the validations associated with Time Management.
-
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.
-
Click Open.
The Validation window opens.
-
Copy the SQL from the SQL field and paste it into an SQL editor.
-
Edit the SQL as needed.
Include the new prefixed token, such as
FLTR.CREATION_DATE.
The prefixed token should be added to theWHERE
clause of the validation SQL.