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

Get Client IP Address from SQL PL/SQL

Hello All, This post explains how to get IP address from PL/SQL. “select owa_util.get_cgi_env(‘X-FORWARDED-FOR’) from dual;” ==================== O/P : 106.203.33.240, 23.205.118.109, 184.27.120.23 Function :- owa_util.get_cgi_env This function returns the value of the specified CGI environment variable. Although the WRB is not operated through CGI, many WRB cartridges, including the PL/SQL Gateway, can make use of CGI environment variables. Reference:- https://docs.oracle.com/cd/E28280_01/portal.1111/e12042/psutil.htm#YPREF417 Continue reading Get Client IP Address from SQL PL/SQL

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

Jasper Report Print when expression field is null or not null

Hello All, When we use jasper report design there will be a option to display a field by condition basis. Use field property “Print when Expression” option to show by condition basis. Show when field is null: new Boolean($F{FIELD_NAME} == null) Show when field is not null: new Boolean($F{FIELD_NAME} != null) Happy reporting with jasper! Continue reading Jasper Report Print when expression field is null or not null

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

Faceted Search – Shopping Cart Example

APEX 19.2 – Faceted Search – Is a important key feature in Oracle Apex 19.2 version, we can find the faceted region in a page or we can directly create a faceted page. – Create a faceted search page and search items. – Modify the Classic Report Template, to show the search results in different UI format. – Choose the Card template and modify the … Continue reading Faceted Search – Shopping Cart Example

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

Get domain name from Email in Oracle SQL

How to get domain name from given email id in Oracle SQL (or) PL/SQL Very easy to get domain name from mail id like ‘thamaraiapex@gmail.com’ => gmail SELECT (substr(substr(‘thamaraiapex@gmail.com’, instr(‘thamaraiapex@gmail.com’, ‘@’) + 1), 1, instr(substr(‘thamaraiapex@gmail.com’, instr(‘thamaraiapex@gmail.com’, ‘@’) + 1), ‘.’) – 1)) as domain_name FROM dual; Result:- gmail Continue reading Get domain name from Email in Oracle SQL

Oracle Apex Customize CSS for Navigation Bar List

How to customize navigation bar list like background color font style? Yes, We can customize the navigation bar list items with User Defined Attributes Use 2nd Attribute to mention your CSS Classes. Mention your CSS Styles in your Global CSS or 0th page Style like below. .help_style .t-Button { font-weight: bold !important; background-color: red !important; } That’s it, now you can showcase your navigation bar list … Continue reading Oracle Apex Customize CSS for Navigation Bar List

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..)