Apex 4.2.2 on Oracle 11.2 using EPG in Linux
I have a Pie chart and I want user to be able to click on a section and refresh a classic report region below the chart on the same page. I have used various methods to try to get this to work but none have succeeded. Here is what I have right now - when a click is made on the pie a value is returned to a text field P19_STATUS in the report region using javascript in a DA:
AnyChart.getChartById($("#chart2_chart object").attr("id"))
.addEventListener("pointClick", function(e){
$s("P19_STATUS", e.data.Name);
});
This works fine as I can see the value which is the label from the chart. I created a second DA with a Change event for item P19_STATUS. There is one TRUE action - Refresh. Selection Type: Region, Region: Classic Report (40). I also set Enable Partial Page Refresh to Yes on the Classic Report and Page Items to Submit: P19_STATUS. When user clicks on the pie the value is set fine in P19_STATUS but the report does not refresh. FYI I also tried $("#report_region_id").trigger("apexrefresh"); in the second DA but that did not work either. I only want the region to refresh, not the page. please help - I'm fairly new to Apex so please be as detailed as possible. Thanks!