About Using SQL Filters

Use SQL statements to select industry model records. The SQL Filter dialog box shows the select statement used by the active filter, such as

• rownum<101 for a start filter or
• (AREA > 300) AND (ID_QUALITY = 2).

The dialog box also displays OrderBy clauses defined in the form designer options. You can set these options, but you must separate the Order and the By expression with exactly one blank space.

You can use input parameters in SQL filter select statements, such as a length, which the user is prompted to enter. An input box will appear. If the parameter is a numeric value, you must use the # character. If it is a text value, use the $ character.

Example: {#length} {$Name}

select * from WW_SECTION where
pipe_length > {#Length}

Note:

For better performance this filter is not saved, but you can save and reuse filter definitions.