How to change modal dialog title dynamically in oracle apex

Question: How to change modal dialog title dynamically in oracle apex ? Answer:    Yes, It’s possible to change modal dialog title when page load. How: Using apex_util package Step1: Create dynamic action on page load Step2: Enter below code apex.util.getTopApex().jQuery(“.ui-dialog-content”).dialog(“option”, “title”, “Your title”); Step3: Run your dialog you can see dynamic title based on page item. Reference: See apex documentation Apex API Reference     Continue reading How to change modal dialog title dynamically in oracle apex

Oracle Apex interactive report fix column width

We can customize an interactive report column width as min or max pixels, let us see how its possible. Step 1:- Expand interactive report column properties, in that use HTML Expression as “<span class=”com-wrap”>#COMMENTS#</span>“ Step 2:- Expand page properties in that use Inline CSS Properties span.com-wrap { width: 100%; word-break: break-all; } “word-break” css will break the text content once reached overflow. We can customize an … Continue reading Oracle Apex interactive report fix column width

Print CLOB Content in Oracle Apex

How to show clob content in oracle apex page ? is it possible to show ? Yes, Possible to print clob content in oracle apex page with using of PL/SQL Dynamic Content Region. Step 1: Split CLOB content into small pieces of content with using of dbms_lob.read procedure. Example Code Snippet: DECLARE CURSOR crec IS SELECT html_message FROM mails_t WHERE email_id = 1001; rrec crec%rowtype; l_amt … Continue reading Print CLOB Content in Oracle Apex

Oracle Apex Use of apex_web_service.make_rest_request

Instead of use UTL_HTTP.BEGIN_REQUEST in PL/SQL oracle apex offered to make web service request through “apex_web_service.make_rest_request” API.  Example Web Service Sample URL: http://quotes.rest/qod.json Syntax:- DECLARE l_response CLOB; BEGIN l_response:= apex_web_service.make_rest_request(p_url => ‘http://quotes.rest/qod.json&#8217;, p_http_method => ‘GET’ ); END; Webservice Response:- { “success”: { “total”: 1 }, “contents”: { “quotes”: [ { “quote”: “If you want to test your memory, try to recall what you were worrying about … Continue reading Oracle Apex Use of apex_web_service.make_rest_request

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. Step 1: Create Custom Dynamic Action Step 2: Create Custom Event : dialogclose, Selection Type as : Jquery Selector, jQuery Selector : body That’s it we can refresh the report region when close dialog.   Continue reading Refresh Report Region when Click Modal Dialog Close Button

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. Continue reading Hide Unwanted Columns In IR Report Download (CSV, HTML, PDF..)

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. Continue reading Add style dynamically in interactive report

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. Continue reading Apex Views and Usage

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 Method 2: For every calling page have to create individual branch for send parameters to parent page. Continue reading Call Parent Page from Modal Dialog Dynamically

How to open Inline Modal Dialog in Oracle Apex

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.

 

Step1
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”