Posts

APEX on the Autonomous Database ATP & ADW Cloud Service

Image
Yesterday at the KScope19 conference, Oracle announced the immediate availability of APEX, ORDS, and SQL Dev Web on Autonomous Database Cloud! Chaitanya Koratamaddi dedicated an entire session on presenting the possibilities of APEX on the Autonomous Transaction Processing (ATP) and Autonomous Data Warehouse (ADW) Cloud Service Oracle offers. APEX on Autonomous: What is it? You get a dedicated Application Express 19.1 instance managed by Oracle. Installation, Upgrade and Instance Configuration tasks of APEX on ATP/ADW are completely managed by Oracle, including ORDS. Why choose for APEX on Autonomous? The provisioning of new environments is instantly and effortless within minutes. You will get a pre-configured, fully managed and secured environment to both build and deploy APEX applications. You can start developing immediately as soon as your DB service is provisioned. Provisioning is done in three simple steps: Sign in to Oracle Cloud Infrastructure Console

KScope19 - Future of APEX

Image
I’m currently attending the annual ODTUG conference, KScope 19, this year organized in Seattle, Washington. Traditionally the Sunday Symposiums, the first day of this 5 day conference, are provided by the Oracle Development teams, presenting the latest and upcoming features of their products. Naturally I went to join the APEX symposium and this is a brief summary of subjects and features that I consider worth mentioning. LOV on Steroids 19.2 will introduce a new and revamped Popup LOV component. The functionality will be hugely enhanced with features we were only used to get from plug-ins like Select2 (who does not use this?!). With 19.2 we will have all the features: Display Popup as Modal or Inline (Combo-Bob like), the modal flavor is resizable Display Multiple Columns Search, in multiple columns, fully configurable Sorting, presorted and user enabled Automatic/manual initial fetch Select multiple values (like a tag list) Add new values Search as you typ

APEX 18.1 UT Touch Gestures Fix

Image
If you tried using the build-in Touch Gestures (hamer.js) of APEX 18.1 Universal Theme on your Android device (or Chrome Device Simulation Tool on your desktop), you might have noticed the Swipe and Pan doesn’t work. Here’s how to fix this: add an on-load Dynamic Action and execute this JS snippet: delete Hammer.defaults.cssProps.userSelect; Hammer(document.body, {}); (many thanks to Shakeeb) P.S:  You can try/test the Touch Gestures in the Universal Theme Reference Application

Describing ORDS RESTful Services using a WADL

Image
Recently I got this question (or better specification) from a customer:   "For exchanging  data ,  we either want a SOAP webservice or a REST service offering a WADL ".   WADL?   What's a WADL? I know WSDLs as descriptive endpoints for SOAP webservices, but WADL?! It occurs, that WADL's are intended to do just that, but in a more generic way.  WADL  stand for  Web Application Description Language .  The  World  Wide Web  Consortium (W3C) currently has no plans to implement  WADL  as a standard. Oracle's  ORDS is going the  swagger / openapi  route which is partially implemented in the 17.3 release .   With no existing functionality to provide a WADL for Oracle RESTful services, I had to come up with  my own solution, using the APEX  re pository  views to generate a WADL endpoint. I came up with a  small  procedure for this and add an additional URI Template to my service, called " wadl " with a single GET Resource Handler calling this

APEX SmartPivot Plug-in: Release 1.1

Image
  The  APEX SmartPivot Plug-in is an Oracle Application Express Plug-in that enables users users to analyze data much like they are used to in Excel. It allows to present data in a customizable multilevel data grid. Developers can add the plug-in to any APEX application, just like adding an interactive report. Website:  www.apexsmartpivot.com What’s new in Release 1.1 The new release of the APEX SmartPivot Plug-in focuses on integration with the latest APEX version: Users/UI Enhancements Font APEX The UI now supports Font APEX in APEX version 5.1 (Font Awesome in APEX 5.0). Your pivot report will look consistent with the rest of your application. Font APEX can also be used in conditional formatting rules. Conditional Formatting Users can define, apply, save and share conditional formatting rules with a report layout. Conditional formatting is not restricted to setting text and background colors, but offers to translate (ranges of) values i

Kscope16 APEX Symposium (live) Log

The Kscope16 APEX Sunday Symposium is entirely dedicated to the upcoming 5.1 version, naturally. Most of the information on APEX 5.1 has been presented at conferences earlier this year, but here at Kscope there are 7 sessions from APEX Development team, entirely dedicated to APEX, which makes this the single most important one-event source of APEX news. Here a short summary of the, in my opinion, highlights from the presentations of the Oracle APEX development team´s presentations. 1) Shakeeb showing improvements and new features in Universal Theme 5.1 - Font APEX icons replacing Font Awesome. That is: you can choose, but the APEX team did a wonderful job on the APEX Font, like adding declarative icon modifiers (an icon with an additional small icon in the lower right corner) in a different color. This is not only easy to use and very beautiful, but very useful too. I like this a lot. - Themeroller like enhanced inline modifying of template options of Page Items, Region

(Unconfirmed) New Features APEX 5.1

Image
by  @APEXORADEV Following the news feeds on the internet, tagged #orclapex, a series of slides presented at a UKOUG event came along that I think are worth to get summarized in a blog post and shared with the community. It's a list of (unconfirmed) new features we could find in APEX release 5.1. The list looks impressive. The APEX Development Team once again would prove, that development of APEX is much driven by developer/community feedback and customer demands. ·          Interactive Grid o    Modern, rich & interactive multi-row editing o    Used for Master > Detail(s), Master > Detail > Detail o    Great for existing Forms customers, who are used to having rich Master > Detail blocks o    Interactive Report style end-user customization, but better! o    Mid-term goal to replace Interactive Reports, Tabular Forms and Websheet Data Grids o    Fast, Responsive, JSON-based, lightweight AJAX communications o    Using jQuery UI Widget Factory o    Infinite s