Example of Custom Text Field Configuration in a SQL Template

The following steps illustrate the advantage of Custom Text Fields.

In the SQL Template Designer, select the Custom Text Fields component and click Configure.
In the Custom Text Fields window, define a field named Host ID with a data type of Number and click OK.
To use this newly configured Custom Text Field, be sure to select the checkbox.
In the Query window, enter the following SQL query by typing a partial statement and then double-clicking to select fields:
```
select * from aps_v_host_volume where host_id > ${freeText1}
```
This query can be constructed by combining typing with double-clicking selections in the window, as shown in the following example. For a complete list of database views and columns, you can access the Database View Help.
See Access Help for Database Views.
See Help for Database Views.
- Enter a partial query: select * from aps_v_host_volume where
- Double-click a field to insert the name into the query.
- Type an operator: >
- Double-click the freeText1 variable to insert it into the query.
The resulting query will be:
```
select * from aps_v_host_volume where aps_v_host_volume.host_id > ${freeText1}
```
Click Validate Query.
In the Formatting window, select all the fields for a table.
Save the report template with a name and a menu group.
Generate the report from this report template and in its Scope Selector window, provide a value for the Host ID field. This value will be passed to the query.