Refresh Report Region when Click Modal Dialog Close Button

Hope we face this issue when click  “X” button report region could not be able to refresh report region, We can achieve this from Creating Custom Dynamic Action.

refresh_modal_dialog

Step 1: Create Custom Dynamic Action

Screenshot_2

Step 2: Create Custom Event : dialogclose, Selection Type as : Jquery Selector, jQuery Selector : body

Screenshot_3

That’s it we can refresh the report region when close dialog.

 

Advertisements

Hide Unwanted Columns In IR Report Download (CSV, HTML, PDF..)

Dear Friends,

We are facing the report when unwanted columns also downloaded from “IR Report” CSV, PDF, HTML and etc..

For this we have server side condition for a column to hide when download the report.

“NVL(:REQUEST,’EMPTY’) NOT IN(‘CSV’,’XLS’,’PDF’,’XML’,’RTF’,’HTMLD’)”

If we have the conditon on that column it will not included in the report.

Hope it will be usefull to us.

Add style dynamically in interactive report

Have a requirement, find a text in interactive report and add a style for that entire row.

$(‘td:contains(“TOTAL”)’).filter(function() {
//$(‘tr td’).attr(‘style’, ‘font-weight: bold’);
// $(‘tr td’).css({ ‘background-color’ : ‘green’})
$(this).closest(‘tr’).css({ ‘font-weight’ : ‘bold’});
});

Above code find a “TOTAL” text and convert into bold for that entire row.

Apex Views and Usage

apex_application_page_items

To find / get detailed information about the page items and their properties  by using apex_application_page_items apex view.

Example:  for example i need below column information

item_name,  page_name, region, region_id, item_default

SELECT
item_name,
page_name,
region,
region_id,
item_default
FROM
apex_application_page_items
WHERE
application_id = 1127
AND item_name LIKE ‘%DEPARTMENT_NAME%’
AND item_source_type != ‘Database Column’
ORDER BY
2

Execute above query and get exact result.

Call Parent Page from Modal Dialog Dynamically

Call parent page from modal dialog dynamically, but how ?
Method 1: Create one non-database item; for that item value, send the source page no from calling page. Then create one branch after page processing time, now page no should be your non-database item. Below for the reference

modal_dialog

Method 2: For every calling page have to create individual branch for send parameters to parent page.

Oracle Apex is the latest one!