Recent Posts by Carsten Czarski

This blog posting describes how to add a chart region to a page containing the new Faceted Search feature. Chart display is always in sync with Faceted Search report display. Since APEX does not support this out-of-the-box yet, we'll utilize a very interesting enhancement to the APEX_REGION PL/SQL package, which was introduced in the latest Application Express Release 19.2: APEX_REGION.OPEN_QUERY_CONTEXT function provides access to the data of another region on the page. FUNCTIO...

One of the most exciting new features in APEX 19.2 is Faceted Search. Faceted Search (or faceted navigation) is seen pretty often on the internet; typically on shop or sales web sites. The end user can set filters using Facets on the left or upper side of the screen. A facet shows possible values together with the occurrence count within the result set. After the end user changed a facet, results, dependent facets and occurrence counts refresh immediately. And you can try that...

It's getting close: In about 5 weeks, the Oracle developer community will meet in Seattle for the annual ODTUG KScope conference. KScope19 will contain over 300 technical sessions, hands-on labs, "Sunday Symposiums", and (of course) networking with Oracle experts from all over the globe. The Oracle APEXdevelopment team will be there, not only with sessions about new features, but also with deep-dive sessions on existing functionality as well. So don't miss this opportunity to...

In the latest Application Express release 19.1, the Data Loading component in SQL Workshop has been dramatically improved. Not only CSV files, but also JSON, XML and XLSX files can be loaded into tables in the APEX workspace. However, some readers might already have noticed, that the new Data Loading wizard can only load into new tables. To accommodate SQL Workshop users needing to load data into existing tables, the functionality from previous APEX versions is still...

by Andreea Dobre, Oracle Romania in Bucharest, and Carsten Czarski, Oracle Application Express Development team. One of the new features of Application Express 19.1 is the new Data Loading wizard, which already has been introduced in the Quick and Easy Data Loading with APEX 19.1 blog posting. But there is more than the new wizard in SQL Workshop - the new APEX_DATA_PARSER PL/SQL package provides a nice and easy developer interface to parse files.  The APEX_DATA_PARSER...

The latest Application Express Release 19.1 takes its support for external data sources (REST Services and REST Enabled SQL) to the next level. Forms do now support REST services and REST Enabled SQL declaratively. Thus APEX allows to create report, chart and form pages on REST services - all declarative and without manual coding. This blog posting shows, how it works. Prerequisites I: Create a table and load sample data First, we need a REST service, to create the APEX...

Starting with APEX 18.1, some significant changes where introduced on how APEX components (report, charts, calendar and others) get data. In earlier versions, each component generated their own SQL query. That was fine as long as APEX only worked with data in the local database. However, with the requirement to support external data sources like REST (Web Source Modules) or REST Enabled SQL, components cannot generate their own SQL any more. An example: End users view an...

The upcoming Application Express Release 19.1 (try it out on the Early Adopter Instance) also contains new features for the Interactive Grid component. Based on actual customer feedback, the APEX development team added some more declarative options for Interactive Grid. Tasks, which required adding Javascript code in earlier versions, are now done with a simple mouse click. That makes Interactive Grid easier to use and more maintainable. This (short) blog posting provides...

The latest APEX Early Adopter Release 19.1 introduces a lot of new functionality for forms. First, there is REST Service and REST Enabled SQL support for forms, as outlined in the Statement Of Direction. This will be covered in a separate blog posting in more detail. Today we have a look at some other, general changes to form pages in APEX 19.1. The most straightforward way to do this is to log into the Application Express 19.1 Early Adopter Instance, create a new application...