Showing information on IR Region

declare
total_row number;
begin
select count(1) into total_row from emp;
apex_json.open_object; -- {
apex_json.write('total_rec', total_row); -- "total_rec": "value"
apex_json.write('result', 'success');
APEX_JSON.CLOSE_OBJECT ();
apex_json.close_all;
exception
when others then
apex_json.open_object; -- {
apex_json.write('result', 'fail');
APEX_JSON.CLOSE_OBJECT ();
apex_json.close_all;
end;

step -2 create a page load dynamic action
action- javascript

apex.server.process( "getTotalHours", {
x01: "test",

}, {
success: function( data ) {
if (data.result=='success'){
var total_hour=data.total_rec;
$('#abc_toolbar').after("<div style='color:red'><center>total_hour</center></div>");
}
},
error: function( jqXHR, textStatus, errorThrown ) {
console.log(jqXHR+'--'+textStatus);
}
} );

2

Share
Share
- Share on Facebook
- Share on Twitter

Zulqarnain Haider
12 Questions
18 Answers
0 Best Answers
105 Points
View Profile
Zulqarnain Haider Professional
2020-11-09T14:02:04+05:30Replied to answer on November 9, 2020 at 2:02 pm
Hi Afzal
I want to show Total Sal on top of the IR. I follow this step but no result any solution???
- 0
- Share
  Share
  Share on Facebook
  Share on Twitter

afzal · Answer 4 · 2020-11-10T10:59:14+05:30

step-1 give static id for your report, like = abc

step-2 create ajax callback process name-- calculate

declare
total_sal number;
begin
select sum(salary) into total_sal from employee;

apex_json.open_object; -- {
apex_json.write('total_salary', total_sal );
apex_json.write('result', 'success');
APEX_JSON.CLOSE_OBJECT ();
apex_json.close_all;
exception
when others then
apex_json.open_object;
apex_json.write('result', 'fail');
APEX_JSON.CLOSE_OBJECT ();
apex_json.close_all;
end;

step -3 create dynamic action name-- add_header
event- page load
action-- execute javascript code

/* ajax call back process name "calculate" and here "calculate" should be same */
apex.server.process( "calculate", {
x01: "test",

}, {
success: function( data ) {
if (data.result=='success'){
var total_hour=data.total_salary;

var txt="<div style='color:red;border-style: solid'><center>hello--"+total_hour+"</center></div>";

$('#abc_toolbar').after(txt);
}
},
error: function( jqXHR, textStatus, errorThrown ) {
console.log(jqXHR+'--'+textStatus);
}
} );