HardLikeSoftware – Page 3 – The writings of John Snyders, mostly about software.

APEX 5.2 Interactive Grid

Published Wednesday, February 7, 2018 by John Snyders

Note this is about a future release of APEX and the final release may differ from what I describe.

As of this writing Application Express release 5.2 [Update: the release is renamed 18.1] is a work in progress but you can be an early adopter. Try it out and give us feedback. My experience working on APEX 5.2 has been quite different from 5.1. In the previous release I, along with a few others were laser focused on Interactive Grid. In contrast my work on 5.2 feels like a flood light shinning on many area, some not even identified during release planning. In this series of articles I give my perspective and some technical details on things that I have worked on. Lets start with Interactive Grid.

4 Comments

APEX IG Cookbook for 5.1.4

Published Monday, January 1, 2018 by John Snyders

[Update 30-Mar-2019 there is a new version of IG Cookbook here]
Happy New Year. I wanted to get this IG Cookbook update out the same week that APEX version 5.1.4 was released and Early Adopter for 5.2 came out but a technical problem (described below) and the holidays slowed me down. I will have some things about 5.2 EA to blog about soon. Download IG Cookbook release 3.0. As always make sure you install the Sample Interactive Grid app first because it creates some needed tables.

10 Comments

Wooden Fidget Spinners

Published Saturday, December 30, 2017 by John Snyders

My daughter, Isabella, and I made twenty fidget spinners with wood and old skate bearings for Christmas presents. I tweeted the steps with pictures but here is a little more detail about how we turned old skate bearings into wood fidget spinners.

Comments closed

Visibility and Size Managed Components

Published Tuesday, November 7, 2017 by John Snyders

For no particular reason other than I feel like writing about it, I’ll now describe some minor functionality that crept into the APEX 5.1.1 patch release. Typically a patch release shouldn’t and doesn’t have any new functionality but sometimes there is no better way to fix a bug. This topic is for the advanced plug-in developer and anyone curious about the internal details of APEX JavaScript. No screen shots, no demo app, no sample code, just raw information; sorry.

2 Comments

APEX IG Cookbook Update

Published Monday, July 24, 2017 by John Snyders

Here is an update (revision 2) of the Interactive Grid Cookbook. You can download it here. This revision adds an example of reordering rows. This…

8 Comments

APEX Interactive Grid Cookbook

Published Monday, July 10, 2017 by John Snyders

[This app has been updated] At Kscope17 I gave a presentation called “APEX 5.1 Advanced Interactive Grid” that showcased many examples of whats possible with…

13 Comments

APEX Client-Side Validation

Published Wednesday, May 10, 2017 by John Snyders

There is a new little known sorta feature in APEX 5.1 called client-side validation. You may have missed it because it is not listed in the release notes under new features and only mentioned cryptically, almost tangentially, in the release notes section “Compatibility Mode Changes in Mode 5.1”. It says

“… buttons where the Execute Validations attribute is set to Yes also perform some client-side validations (such as item required checks) and will not submit the page until all issues are fixed”

Other hints and evidence for this feature are the new apex.page.validate function, the validate option to apex.page namespace submit and confirm functions, and the new apex.item getValidity and getValidationMessage functions.

1 Comment

Add Checkbox Selection to APEX Tree Region

Published Wednesday, April 12, 2017 by John Snyders

Hopefully you have already converted to the APEX Tree implementation. This is important because the deprecated jsTree implementation will be removed in the next release of APEX so that we can update jQuery and Oracle JET libraries to the latest versions. Some people are still using the jsTree implementation because they have custom code to do things such as checkbox selection. Questions about how to do this and other things with the APEX Tree have come up many times on the APEX forums.

This article will describe how to add multiple selection with checkboxes to the APEX tree region. You can try it out here. You can also download the app. It is a 5.1.1 app but this technique should work in 5.0 as well.

2 Comments

How to hack APEX Interactive Grid Part 4

Published Friday, March 31, 2017 by John Snyders

In this fourth and final part of the series I’ll cover events and working with the data model. I’ll assume you have read parts 1, 2, and 3 and have at least intermediate level experience with APEX and JavaScript. A very important point is that the information in this article applies to APEX version 5.1.1. Some things may work in 5.1 but I’m not going to bother distinguishing which. Anyone programming Interactive Grid should move to 5.1.1 as soon as possible.

9 Comments

APEX Interactive Grid API Improvements in 5.1.1

Published Tuesday, March 28, 2017 by John Snyders

Normally there isn’t too much excitement around a patch set release but if you are programming Interactive Grid (IG) then APEX 5.1.1 is a big deal. A number of improvements were made to IG and its component parts that make it easier to configure and control from JavaScript and in some cases make possible things that weren’t possible before. Even if you are using IG without client side custom code you will be interested in 5.1.1 for the 31 bugs that have been fixed. IG will continue to get better and 5.1.1 is a good next step.

2 Comments

How to hack APEX Interactive Grid Part 3

Published Monday, February 20, 2017 by John Snyders

If you haven’t read parts one and two yet you probably should before proceeding with this one. They covered some basics, configuration and toolbar and menu customization. In part 3 I’ll explain how to control and interact with Interactive Grid (IG) using JavaScript. As was already mentioned in parts 1 and 2 this is aimed at people with at least intermediate level experience with APEX and JavaScript Also most of the APIs are not documented or supported.

[Update 5.1.1 28-Mar-2017] This article has been updated to reflect patch release 5.1.1

10 Comments

How to hack APEX Interactive Grid Part 2

Published Tuesday, January 24, 2017 by John Snyders

Part one of this series covered Interactive Grid advanced configuration. This part is about a specific area of configuration, which is toolbar and menu customization. This blog series assumes at least intermediate level experience with APEX and JavaScript.

[Update 5.1.1 29-Mar-2017] This article has been updated to reflect patch release 5.1.1

6 Comments

HardLikeSoftware Posts