Learn to configure the <label_value_query_default> element for Pull Reports™ Ad Hoc report and data service software.

Table of Contents

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.