Oracle & APEX Geekery

Posts

KScope19 - Future of APEX

- June 25, 2019

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

- September 05, 2018

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

- December 22, 2017

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

- October 13, 2017

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

- June 26, 2016

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

- October 16, 2015

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

Search This Blog