Tag Archives: APEX 5.0

APEX Interactive Report Checkbox Row Selection

The question of how to add checkboxes to interactive reports comes up often. Usually the problem is not getting the checkbox to display in a row but in how to do something useful with the checked state. There are many forum or blog posts on this topic but they all seem to be rather dated. Even when the general idea is still applicable they use outdated practices including:

  • Inline event handlers using onchange or onclick attributes. These should be dynamic actions.
  • HTML regions with script tags in them or script tags in the HTML Header page attribute. There are much better ways to get JavaScript on a page now. Consider JavaScript File URLs, Function and Global Variable Declaration, and Execute when Page Loads attributes as well as dynamic actions.
  • Making ajax requests using the htmldb_Get API. This should be replaced with dynamic actions or apex.server.process API calls.

So I thought I would take a stab at solving this problem.

Continue reading APEX Interactive Report Checkbox Row Selection

APEX 5.0 Custom Menus

This topic has been motivated by a few different APEX forum threads as well as direct questions from teammates. Here I will show how to add a menu button to each row of an interactive report that will open a menu and the menu item actions will be specific to the row.

Custom Menu Demo

The above pictured Custom Menu Demo is available to try out and to download. This article assumes some familiarity with APEX and JavaScript.

Simple Popup Menu

Before going into how to create a custom menu let me make sure that we all know how to create a simple list based popup menu.

Continue reading APEX 5.0 Custom Menus

APEX 5.0 Dialogs

My guess is that if asked what APEX 5 UI feature is the most complex, most people would say Page Designer. It is true that Page Designer is big, as in a lot of code, but it is also very modular and you can understand each part and then how they work together. Another good guess would be Universal Theme because it is very broad in scope, has fancy CSS that must work cross browser and some nifty behaviors such as collapsible side bars and sticky headers. However, given the title of this article, it should be no surprise that in my opinion the most complex UI feature of APEX 5 is the modal dialog page. Here is why.

Continue reading APEX 5.0 Dialogs

APEX 5.0 Interactive Report Customization

The improvement to Interactive Reports in APEX 5.0 has gotten mixed responses. Many people are very happy with the improvements, which include: multiple interactive reports per page, fixed headings, improved looks, improved usability, improved markup, and new features such as pivot.

However, people that had previously customized their apps by leveraging internal unsupported functions of Interactive Reports are lamenting the loss of the gReport variable that enabled those customizations.

The improvements in 5.0 and any future improvements necessitated restructuring the code to isolate the internal details. What was left out is an API to the useful features that people had discovered and shared. As Anthony mentioned on the OTN forums this is something that we hope to rectify in the future. The rest of this article is for the curious and impatient.

Continue reading APEX 5.0 Interactive Report Customization

Right-to-left Support in APEX 5.0

This post contains statements about possible future functionality. These are not official statements. They are speculative, subject to change, and should not be relied upon.

Right-to-left direction support (RTL) was not a stated goal or feature for APEX 5.0. That hasn’t stopped a number of people from asking about it; why no RTL support?, how do I create an app using RTL direction? For someone building an APEX app in a right-to-left language the Universal Theme doesn’t seem very universal.

Although RTL is not a 5.0 feature it doesn’t mean we completely ignored the issue. Here I will describe and demo what can be done today and hint at future possibilities. It isn’t a ready to use solution but should help get you started. We intend to improve RTL support over time including some out of the box capabilities in Universal Theme in a future patch release. Think of what I demo here as a progress report.

Continue reading Right-to-left Support in APEX 5.0