Posts

Showing posts from January, 2021

Printing Page Numbers in RTF Template [Oracle BI Publisher]

Image
Here I am giving an example to print the page numbers dynamically in the RTF (Rich Text Format) template. Step 1:  Go to page footer and copy and paste the below script. Page |  <?fo:page-number?>  of  <?fo:page-number-citation:xdofo:lastpage-joinseq?> <fo:page-number> :   This is the object, which is used to represent the current page-number. <?fo:page-number-citation:xdofo:lastpage-joinseq?> :  This is the syntax, which is used to represent the total number of pages. Step 2:  Load the XML and preview the result. Output: That's it. References: fo:page-number Printing Page Number Code in Oracle XMLP RTF Template

Remove X (Close Mark) from Oracle APEX Modal Dialog

Image
  Here I am giving an example to remove X (Close Mark) from the Oracle APEX modal dialog. Step 1:  Get a class for X (Close Mark) by following below steps. Place a mouse cursor on Close Mark (X). Right click a mouse (The right mouse button is often used to open contextual menus, which are pop-up menus that change depending where you click) and select the menu "Inspect" . DevTools pop-up comes up when we click on Inspect menu, from there we can get a class (JQuery Selector) for the particular components. Step 2:  Copy and paste below code in page JavaScript (Execute when Page Loads) var button = parent.$('. ui-dialog-titlebar-close ');  button.hide();  Output: That's it. The close mark (X) has been removed. Happy APEXing!!!... Reference: Oracle APEX hide the x on the modal dialog

Oracle APEX Chart Conditional Bar Colors

Image
    Here I am giving an example to change the chart bar colors based on the conditions in Oracle APEX. Step 1:  Create a new blank page. Step 2: Create a bar chart region and your bar chart series query would then look something like this, SELECT fund_id ,          fund_name ,           to_char ( start_date , 'DD-Mon-RRRR' )  start_date ,           case   when  percent_complete >=  75   then   '#d1f5e0'   --light green              when  percent_complete >=  50   then   '#fff4dd'   --light orange              when  percent_complete <=  50   then   '#fdd5cc'   --light red         else   'blue'          end   as  color ,        percent_complete FROM fxgn_fund_progress  order   by  fund_id  ASC Step 3: Do the column mappings. ( Label and Value must be mapped) Once you done the above setup, then your bar chart would then look like this, Step 4: [Enable Conditional Bar Colors]  Click on the chart series and look for the attribute "Color

Embed a Tweet/Timeline to your Oracle APEX Application

Image
  Embed a Tweet:   Note: Embedding Tweets is only available via twitter.com . Step 1:  Click " ..."  the icon located within the Tweet. Step 2:  From the menu, select Embed Tweet. Step 3:  This will open publish.twitter.com where you can customize the look of the embedded Tweet by clicking set customization options. Step 4:  Once you like the look of the embedded Tweet, copy the code provided by clicking the Copy Code button. Step 6:  Create a page in your Oracle Apex Application. Step 7:  Create a region ( PL/SQL Dynamic Content ) to that page and copy and paste the below sample code (replace this with your twitter contents) into that region. begin htp . p  ( '<blockquote class="twitter-tweet">         <p lang="en" dir="ltr">Finally, I have posted 55 technical articles  this year (2020). All About Oracle and Oracle ā&#39;pěks.  <a href="https://twitter.com/hashtag/orclapex?src=hash&amp; r