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 foe 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 ConsoleCreate a CompartmentCreate  an A…

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 Steroids19.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 resizableDisplay Multiple ColumnsSearch, in multiple columns, fully configurableSorting, presorted and user enabledAutomatic/manual initial fetchSelect multiple values (like a tag list)Add new valuesSearch as you type (configurable)Configurable height and…

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/

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 EnhancementsFont 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 into text. For those users familiar with HT…

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, Regions, … - UT JavaScript…

(Unconfirmed) New Features APEX 5.1

Image
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 oModern, rich & interactive multi-row editing oUsed for Master > Detail(s), Master > Detail > Detail oGreat for existing Forms customers, who are used to having rich Master > Detail blocks oInteractive Report style end-user customization, but better! oMid-term goal to replace Interactive Reports, Tabular Forms and Websheet Data Grids oFast, Responsive, JSON-based, lightweight AJAX communications oUsing jQuery UI Widget Factory oInfinite scrolling with fixed headers and columns oRTL support oAccessible, with outsta…