Get Ahead of the Curve with Insum-APEX-Pro
Oracle Application Express (APEX) boasts hundreds of plugins, dozens of talented bloggers, and a thriving help forum. We’d like to release a tool that will help grow the community even further! Introducing Insum-APEX-Pro: A chrome extension that adds extra functionality to APEX Page Designer. To install, open this link and click “Add to Chrome” in the top right. Check out its features below:
- Autocomplete PL/SQL
- Searchable Select Fields
- Altered Property Highlighter
- Altered Property Filter
- Persistent Property Filter
- Persistent Cursor Focus
Do you ever forget the exact spelling of a function? How about the names of its arguments? Now you can see the function as you type it. A tiny pop-up window will show you the function’s arguments. Click the pop-up or hit enter to accept the arguments in the editor. You can also view its documentation by clicking the “more” link. Furthermore, we’ve included almost every documented function from Oracle including the APEX API.
Searchable Select Fields
This feature is exactly as it sounds! Across all of APEX (not just the Page Editor) many select fields are now searchable. The result is no more scrolling through a wall of options! Only select fields with 7 or more options become searchable. Why 7? Applying it to select fields with fewer options was too bulky. The search limits your options as you type, so your choice is often less than a few keystrokes away. We built this using Kevin Brown’s Select2 jQuery plugin.
Altered Property Highlighter
A commonly noted issue with APEX is its ever-increasing number of properties. For example, there are over 100 properties in an Interactive Grid with a single column. However, in most cases, only a few of these properties are ever used. Of course, you want to focus on the properties that matter. So, here’s our solution: highlight only the altered properties. I recommend always having this feature turned on.
Altered Property Filter
You can further reduce eye clutter by filtering out unaltered properties. This is especially helpful for developers who are new to a project and trying to understand how the application works. It also helps you to perform quick “sanity checks” when your application is exhibiting strange behavior. We certainly recommend trying this feature out and becoming comfortable using it on a regular basis.
Persistent Property Filter
In APEX 5.0 and 5.1 filters get reset everytime you click on a new component. However, APEX 5.2 fixes this problem by allowing the user to pin the filter. Still, we wanted users of APEX 5.0 and 5.1 to also have a persistent filter as well. This is especially helpful for viewing a particular property across multiple components.
Focus Last Property Selected
This is a feature in APEX 4 that was in fact removed in APEX 5. It’s the ability to stay focused on the same property as you switch between components. Due to popular demand, we’ve put this feature back in. It can be enabled/disabled by clicking the Insum button in the top right. Note: it is disabled by default, but can be enabled by clicking the Insum logo in the top right of the screen.
How Insum-APEX-Pro Works
The chrome extension uses APEX’s public API object. You can examine this object by navigating to page editor in APEX, opening the console in the Chrome Developer’s Toolbar, and typing “pe” (stands for page editor). This will return the API object for your inspection. You can also learn more about Page Edtior’s Public API by downloading APEX, unzipping it, and navigating to apex/images/apex_ui/js/pe.model.js to view its source code.
In conclusion, please feel free to send us feedback on the Insum-APEX-Pro Github page.
Get our latest content delivered to your inbox and stay informed on our upcoming educational events.
Power Ranking Oracle APEX 18.1 New Features – May
FINALLY! After months of anticipation, Oracle Application Express (APEX) version 18.1 has arrived! Taking a look at the new features included definitely makes it...Learn More
Dynamic Actions in Oracle Application Express – Go From Basic to Awesome
If you’re just starting out in Oracle Application Express, know that Dynamic Actions can take your applications from basic to awesome very quickly. And,...Learn More
Collaborative Development in Oracle APEX – Steering Clear of Trouble
The ability to work collaboratively as a team is certainly one of the wonderful aspects of Application Express, Oracle's rapid application development platform. Developers work...Learn More
Progressive Web Apps: Two worlds colliding to everyone’s benefit
The Story of Progressive Web Apps (PWAs) is now playing out at the frontier of two worlds, inside your smartphone. Once upon a time, inside...Learn More
Blockchain – Technology you’ll have to Address, Sooner or Later
Blockchain is a technology buzzword getting a lot of attention these days. At its core, this technology is a means for securing data in...Learn More