Query Object as a Source
This documentation is for Kyvos 2026.2.x. To view documentation for other Kyvos versions, click here. |
|---|
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_Namewith 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.
Note
Ensure the Query Object returns the required fields for the Display and Value columns, just as with a dynamic SQL-based parameter.