Use these fields and options to create SQL expressions.
The expression can be as simple as the column name from a table in the database, or it can be a complex SQL statement with various operators and conditions. The SQL expressions are not validated or evaluated when they are being built. Deltek recommends that you check expressions for accuracy before you save them.
| Field | Description |
|---|
| Columns
|
Select the column for which you want to create an expression. To select a field, double click on it, or select it and click
Add Field. The field name displays in the Expression grid.
The list of columns available for use is based on the workflow table selected. When the main record/table for the hub is selected as the workflow table, the list of columns includes columns from the main hub table and also any form-type or grid-type user-defined fields created for the hub.
Calculations can be simple or complex, and can be created using either the
Calculator or the
Use a Condition tool.
All character/string type fields are added to the expression with qualifiers (single quotes) around them when the
Add Column button is used. All numeric type fields are added with no qualifiers.
|
| Calculator
|
The Calculator tool allows you to create simple expressions using numbers and math calculations. In addition to clicking on the Calculator to select a number or symbol, you can also enter the number or symbol directly in the Expression grid.
|
| Expression
|
This field displays the expression that you created. In addition to creating expressions using the Calculator and Use a Condition, you can also enter conditions in this grid.
To insert a column, click
Insert. If you are using the Use a Condition feature, first select the
Expression field for which you want to enter a column, then click
Insert.
DPS displays a list of columns available for that hub.
To undo the last change you made, click
Undo Last Change.
To clear the expression, click
Clear Expression.
|
