apex_add_chart_drilldown
Add chart drilldown by capturing the clicked series label into a hidden item, then refreshing an Interactive Report to display filtered data.
Instructions
Add chart drilldown: click chart series → set hidden item → refresh IR.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"page_id": "<page_id>",
"chart_region_name": "<chart_region_name>",
"target_item_name": "<target_item_name>",
"filter_column": "<filter_column>",
"target_region_name": "<target_region_name>"
},
"name": "apex_add_chart_drilldown"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| page_id | Yes | Page ID. | |
| sequence | No | DA event sequence number. | |
| filter_column | Yes | The chart series/group column whose label is captured (informational — used in the DA name for clarity). | |
| target_item_name | Yes | Suffix for the hidden item that will store the clicked label. Auto-prefixed with ``P{page_id}_``. Must match the bind variable used in the detail IR SQL. | |
| chart_region_name | Yes | Name of the JET Chart region to listen on. The region must already exist on the page (created with ``apex_add_region(..., region_type="chart", ...)``. | |
| target_region_name | Yes | Name of the IR/IG region to refresh after the item is set. The region must already exist on the page. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |