Hi guys,
I have a page which downloads statspack reports from different servers and stores them in APEX. As well as this it also display a summary of data (top 5 wait events & load profile info) when hovering an icon: http://oi40.tinypic.com/295uxxg.jpg
The chart will refresh itself and display the data based on the value of P10_SNAPVAL (storing the PK value).
The report does not do as I expect it to do (it isn't refreshing the table). I have the following:
PL/SQL Dynamic Content region making the report
Dynamic Action
- Event: Change
- Item: P10_SNAPVAL
- Action: Refresh
- Affected Element: Region - Load Profile (the PL/SQL Dynamic Content)
- Event scope: I've tried both bind & live
The value of P10_SNAPVAL is changed whenever the user hovers a penguin icon (this works because the chart works).
Anyone know why my current setup isn't working with the table/how to fix it?
Edit: Is it something to do with me changing using javascript?
$('img[name=summary]').mouseover(function() {
var get = new htmldb_Get(null,html_GetElement('pFlowId').value, null,10);
get.add('P10_SNAPVAL',$(this)[0].id.substring(3));
var gReturn = get.get();
document.getElementById('P10_SNAPVAL').value = gReturn;
$("#c9485413559485976").show();
$("#loadtab").show();
});
Edit 2: I've tried:
jQuery('#apexir_WORKSHEET_REGION').trigger('apexrefresh');
and every id from apexir_WORKSHEET_REGION downwards (apexir_REPORT,apexir_WORKSHEET,apexir_DATA_PANEL,9587216508806437) but it isn't updating the table values for any of them. I thought this call was to update both normal and IR reports but I tried normal, switched it to IR and it still isn't refreshing. No errors in JS (according to firebug)