Dear All，
After refresh chart area with javascript dynamic action. 2 bars chart X-axis sort by numeric size click label drill no response no value.
1、Add after refresh dynamic action
javascript code:
// Retrieve the chart 'groups' data
var groups = apex.region("myChart2").widget().ojChart('option', 'groups');
// Loop through the groups data to remove the temporary prefix
var groups = apex.region("myChart2").call( "option", "groups" );
for(i = 0; i < groups.length; i++) {
groups[i].name = groups[i].name.substring(4);
};
// Set the chart 'groups' attribute to the updated data
apex.region("myChart2").widget().ojChart('option','groups',groups);
// Refresh the chart to render the revised groups data
apex.region("myChart2").widget().ojChart('refresh');
Chart sql query:
select lpad( Phase,3,'0') || '. ' || Phase as product_name,
'javascript:callme("'||Phase||'");' LINK,
Phase,
decode(required_quantity,0,1.20,round(issued_quantity/required_quantity,2)) quantity,'Component%' customer,
'Component' || chr(10)||
' Phase '|| Phase || chr(10)||
' % '|| decode(required_quantity,0,1.20,round(issued_quantity/required_quantity,2))*100 ||chr(10)||'if %=120 required quantity is zero' as tooltip
from (select Phase,
sum(nvl(issued_quantity,0)) issued_quantity,
sum(nvl(required_quantity,0)) required_quantity
from table_comp_tmp
where organization_code = :P2_IO_CODE
group by Phase)
order by Phase asc
2. Created text item P2_ITEM
3. Interactive report query (gave static id as "my_report")
select * from mis_Component_tmp
where organization_code = :P2_IO_CODE
and phase = :P2_ITEM
4. Add javascript function
function callme(phase)
{
$s('P2_ITEM', phase);
apex.server.process('DUMMY',
{pageItems: '#P2_ITEM'},
{
dataType: "text"
,success: function(pData)
{
apex.event.trigger('#my_report','apexrefresh');
}
}
);
}
If you dynamically mask this section click Label to retrieve the value to the item
//apex.region("myChart2").widget().ojChart('refresh');
Hope this help. how can I have labels 2 bars chart sorted by number size and then click Label to drill the X-axis value to the page item P2_Item
Regards best,
gbhuang