Posts

Oracle Apex : How to Display Images on Cards

Image
  Step - 1:Create Blank Page: Step - 2: Create Cards Region:                 Identification - Type - Cards                  Sample SQL Query:                                      select product_id,                                                product_name,                                                filename,                                                mimetype,                        ...
Post a Comment
Read more

Oracle Apex - How to Display Add, Remove, Delete buttons on the Cards-Using Classic Report

Image
  Step - 1: Create blank page  :  Step - 2:Create classic report region :          Region Name = demo_classicreport   Sample  SQL query:   Select   'name:' || ' ' || product_name || '<br> quantity:' || ' ' || product_avail AS card_text,   filename,   mimetype,   image_last_update,   product_image,   sys.dbms_lob.getlength(product_image) AS card_title,   product_id,---my table primary key   list_price,   apex_util.prepare_url('#') AS card_link,   '<div data-id=' || PRODUCT_ID || '>    <button class="t-button t-button--nolabel t-button--icon trash-me " id="fav_' || PRODUCT_ID || '"          type="button">   <span class="t-icon fa fa-trash" aria-hidden="true"></span>   </button>  <button class="t-button t-button--nolabel t-button--icon add-favorite " id="fav_' || PRODUCT_ID || '"     ...
Post a Comment
Read more

Oracle Apex - How to Display Image and Text Side by Side Using Cards

Image
  Step - 1 : Create Blank Page. Step - 2 : Create Cards Region :                Title - Cards                 Type - Cards Sample SQL Query:           select product_id,                     product_name,                     filename,                     mimetype,                     image_last_update,                     product_image,--blob column                     price,                     product_avail           from demo_product_info Step - 3 : Go To Cards Region  Attributes :    Foll...
Post a Comment
Read more

Oracle Apex - How to redirect to another page when we click on the Static Region

Image
  Step - 1 : Create a blank page: Step - 2 : Create static Content region .                Identification - Type - Static Content Step -3 : locate the header and footer Section for the Static content region:                 Header and Footer - Header Text :                 My Redirection page is :46                 Place the below code in Header Text  :                                    <center><B><H2> <Font color = "red">Today's Offer.</font></center></b>                            <a href="f?p=&APP_ID.: 46 :&SESSION.::&DEBUG.::">                   ...
Post a Comment
Read more

Oracle APEX: How to Display Column Text Color in Interactive Grid with JavaScript

Image
     Step-1:Create a new page in your application and give  name to the page. Step-2: Add below code in page level -  Function and Global Variable Declaration       function highlightIgCell(){            $('.COLOR').each(function(index) {            var td_ele = $(this);            var val = $(this).text();           if(val == 'Preparing')             {             td_ele.attr('style','text-color:RED;color:#d50000 ;font-weight:bold;')             }              if(val == 'Received')             {           ...
1 comment
Read more