Learn to configure the <label_value_query_default> element for Pull Reports™ Ad Hoc
report and data service software.
Catalog Configuration Java API reference:
PlaceholderDefaultQueryLabelValuesProvider
Configures a default SQL query to retrieve a list of labels and values
to be used within a <label_value_list>
as the distinct list of values for the parent
<column>. The default SQL query template is:
SELECT distinct [column.name] FROM [table.name] WHERE [column.name] is not null ORDER BY 1
The query will use the same JNDI DataSource as the enclosing <report>.
See the <label_value_list>
documentation for example usage.
<label_value_list> |