fusion_list_reports
List the BI Publisher reports available on this server, showing each report's bind parameters and defaults, so you know what queries can be run.
Instructions
List the BI Publisher reports this server may run. Call this FIRST.
This is the whole of what is runnable. Arbitrary SQL does not work on a pod
that refuses lexical substitution, so an administrator builds each report's
data model once -- writing its SQL with :bind variables -- and registers it
under fusion.reports in config.yaml. Everything an agent can ask this pod is
therefore some registered report plus a choice of bind values, which is also
the security boundary: no report, no query.
For each report you get its parameters (the bind names it accepts; anything
else is rejected before a round trip) and its defaults (the values used for
the ones you omit). If the answer you need has no report, say so and hand the
user the SQL and parameters it would need -- that is a one-time administrator
task, not something this server can work around.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||