Query Object as a Source

Applies to: Kyvos Reporting

For Dropdown type parameters, values can also be dynamically fetched from a Query Object, instead of writing SQL manually.

Specifying a Query Object as Source

To use a query object as the data source for a parameter:

• Use the following syntax in the Source Statement field:

  <%QO: QO_Name%>

  • Replace QO_Name with the actual name of the Query Object.

This instructs the system to execute the specified Query Object and use its result set to populate the dropdown values.

Benefits

• Promotes reuse of existing query logic.

• Reduces maintenance by centralizing data-fetching logic in one Query Object.

• Ensures consistency in parameter values across different reports and dashboards.