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.
Set row column value into page item using below java script code in dynamic action.
var $CurrentEle=$(this.triggeringElement);
var vFileId=parseInt($CurrentEle.closest(‘td[headers=”FILEDEL”]’).siblings(‘td[headers=”FILEID”]’).text());
$s(‘P278_ROWID’,vFileId);
Make Page button position next to Save Button in “Interactive Grid” using below java script code in page load.
$(function(){
//making Save button together and right side of the deafult search
var a = $(“#SAVE_FORMULA”);
$(“.a-Toolbar-group div[data-action=’edit’]”).after(a);
});
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_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, 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
Method 2: For every calling page have to create individual branch for send parameters to parent page.
Inline modal dialog helps us more in critical situation such as through an error message to user, can execute DML process while through warning pop up message. In this post you can learn how to open inline modal dialog from simple java script code.
Step 1 : Create a inline modal dialog region.
Also give static id for inline modal region ex: “sampledialog” as below snap
Continue reading How to open Inline Modal Dialog in Oracle Apex
