Posts

Showing posts from December, 2020

Showing star rating on Oracle APEX Interactive/Classic Report

Image
  Set the HTML Expression property on the RATING column to: < a href = "javascript:more('#DOCNO#,#DOCDT#');" > < span class = "fa u-hot-text report-star-rating" data-rating = "#RATING#" title = "Click For History" aria-hidden- "true" ></ span > < span class = "u-VisuallyHidden" > #RATING# </ span > </ a > Add this style sheet to the Custom CSS section of the Theme Roller: .report-star-rating { white-space : nowrap; } .report-star-rating [data-rating= "0" ] ::before { content : "\f006\f006\f006\f006\f006" ; } .report-star-rating [data-rating= "1" ] ::before { content : "\f005\f006\f006\f006\f006" ; } .report-star-rating [data-rating= "2" ] ::before { content : "\f005\f005\f006\f006\f006" ; } .report-star-rating [data-rating= "3" ] ::before { content : "\f005\f005...

what is Ajax callback ? Why Ajax CallBack In Oracle APEX

Image
what is Ajax call  and why Ajax  in Oracle APEX Ajax   stands for  Asynchronous JavaScript And XML .  In a nutshell, it is the use of the XMLHttpRequest object to communicate with servers. It can send and receive information in various formats, including JSON, XML, HTML, and text files. AJAX’s most appealing characteristic is its "asynchronous" nature, which means it can communicate with the server, exchange data, and update the page without having to refresh the page. The two major features of AJAX allow you to do the following: Make requests to the server without reloading the page Receive and work with data from the server. So basically, Ajax is a technique used to help you refresh (almost) any region in Apex without reloading the whole page which is so handy because imagine you have many regions on the page but you are only interested in getting the new data of a specific region after applying some filters. Furthermore, you can also get new Data based on use...

Auto Expanding Menu on Hover in Orcale APEX (5.1+ Later)

Thanks for  maxime_tremblay   Such nice  solution     Go to Page 0 ,  Page Load DA -- JavaScript  APEX 5 and 18 (function(ut, $) { var TREE_NAV_WIDGET_KEY = 'nav'; $(window).on('theme42ready', function() {     /* Make sure that the navigation menu is collapsed on page load */     if (ut.toggleWidgets.isExpanded(TREE_NAV_WIDGET_KEY)){         ut.toggleWidgets.collapseWidget(TREE_NAV_WIDGET_KEY);     }     /* Expand on mouse over, collapse on mouse out */     $('.apex-side-nav.js-navCollapsed .t-Body-nav').hover(         function(){             ut.toggleWidgets.expandWidget(TREE_NAV_WIDGET_KEY);         },         function() {             ut.toggleWidgets.collapseWidget(TREE_NAV_WIDGET_KEY);         }     ); }); })(apex.theme42, apex...