To enable an advanced report to be displayed in context-sensitive report lists in the
Execution Plans tree or on the
Runs page:
-
Create a report that includes one of the following:
- An execution-plan ID as an input parameter for the report to be displayed in the
Execution Plans tree.
- An execution-plan-run ID as an input parameter for the report to be displayed on the
Runs page.
For additional information, see
Creating New Reports and
Writing Advanced Queries with SQL.
-
To make an advanced query available in the context menu of the
Executions area, insert the parameter name
execProp_Id_0 as input for
ExecDef_ID_pk_fk.
For example, your report's SQL statement might have defined a hard-coded database-column value, such as
ExecDef_ID_pk_fk = 68. To edit this report so that it receives column-name values dynamically, replace the static value of
68 with
${execProp_Id_0 | 68}.
Note: For additional information about tables and column-name definitions, refer to the
Silk Central Database Model Schema.