When Filter Before Display is set to Yes, Oracle Forms displays a query criteria dialog before displaying the LOV. End users can enter a value in the query criteria dialog to further restrict the rows that are returned by the default SELECT statement that populates the LOV's underlying record group. Oracle Forms uses the value entered in the query criteria dialog to construct a WHERE clause for the SELECT statement. The value is applied to the first column displayed in the LOV. A hidden LOV column is not displayed.
The WHERE clause constructed by Oracle Forms appends the wildcard symbol to the value entered by the end user. For example, if the end user enters 7, the WHERE clause reads LIKE '7%' and would return 7, 712, and 7290.
Keep in mind that once the end user enters a value in the query criteria dialog and the LOV is displayed, the LOV effectively contains only those rows that correspond to both the the default SELECT statement and the WHERE clause created by the value in the query criteria dialog. For example, consider an LOV whose default SELECT statement returns the values FOO, FAR, and BAZ. If the end user enters the value F or F% in the query criteria dialog, the resulting LOV contains only the values FOO and FAR. If the user then enters the value B% in the LOV’s selection field, nothing will be returned because BAZ has already been selected against in the query criteria dialog.
Applies to LOV
Set Oracle Forms
Default
No