LOV Configuration and Parameter Binding

The LOV query must select the two mandatory columns value and description. It may also include an optional id column at the beginning of the select clause. If the optional id column is included, this value takes precedence and is used as the parameters `:bind` value for report execution; otherwise, the value column is used for binding.

If you modify a shared LOV’s query via the parameter definition, the changes affect all parameters referencing it. To modify it for the current parameter only, you should switch the parameter type to LOV Custom before modifying the query. This creates an ad hoc LOV unique to your report.

The Validate From List checkbox, when checked, enforces selection of a record from the LOV and does not allow the use of wildcards. The Filter Before Display setting is specifically used to avoid performance issues for large LOVs. If its checked, the user is prompted to enter a partial value before the LOV displays, preventing a slow initial query of all possible values.

If you are using LOV Custom, you can click on the Save as shared LOV button within the LOV Query field window to promote that ad hoc query into a reusable, shared LOV definition.