rimblas

[rimblas]

Am I running from inside a (DBMS_SCHEDULER) Job?

I’ve talked about improving your code instrumentation in the past, in particular how to use conditional compilation for your extra logger calls. See Debugging, Logger & Conditional Compilation for the details. This time, I had a different situation. How do I reduce the logging information if my code is running as a scheduled job? I figured if an application (user) executes the code or a…

[rimblas]

Video: Using apex.server.process for AJAX calls in APEX

Video: Using apex.server.process for AJAX calls in #OrclAPEX

If you’re just getting started understanding AJAX and Dynamic Actions, I recommend you watch my “Getting Started with AJAX” video first.

This video is the next installment. Alexis Galdamez and I get into the weeds talking about apex.server.process We cover how you can evolve from declarative Dynamic Actions to programmatic JavaScript AJAX calls.

[youtube=https://www.youtube.com/watch?v=yyuoIcF7hPI…

[rimblas]

A Single Dynamic Action to Refresh Multiple Reports

A Single Dynamic Action to Refresh Multiple Reports

Normally, if you want to refresh a report after a Modal Dialog closes you would create a “Dialog Closed” Dynamic Action (DA), and the True action would be Refresh selection the Report.

However, recently I had a very interesting situation where a page had many reports that could open a dialog. Let’s just call it dozens of reports for the sake of argument. In this situation, instead of creating a…

[rimblas]

Video: Getting started with AJAX in #orclAPEX Are you curious about what AJAX is or how it works in Oracle APEX?My friend…

[rimblas]

Use APEX Shortcuts for your Clear Item Button or Link

Use APEX Shortcuts for your Clear Item Button or Link

You probably know how to add a button or link to clear the value of an item. You may have seen the button on apex.world when you search for a plug-in, for example.

apex.world plugin search

You can use a Dynamic Action that executes a “Set Value” or a fairly straight-forward code like this:

<a href="javascript:$s("P1_SEARCH", "")">Clear</a>

What I like to do is define APEX Shortcuts.…

[rimblas]

The OCD Table Column Re-Orderer

The OCD Oracle Table Column Re-Orderer

Don’t you hate it when you have to add a new column to your carefully handcrafted table and it’s now at the end of the table? Away from it’s proper and logical place within the other table columns. Yes?  Well me too. Enter The OCD Table Column Re-Orderer, a simple APEX application where you can drag & drop your columns to their proper location within a table.

Get it from the repo github.com/rimbl…

[rimblas]

Style your apex_lang.emit_language_selector_list

Style your #orclAPEX language selector list from apex_lang.emit_language_selector_list

If you have a translated app, starting with APEX 18.1, there’s a super simple way to display a language selector: apex_lang.emit_language_selector_list;

However, this is the default output:

I rather make it a bit prettier and get this:

To accomplish that, I had to add a line of JS and two CSS rules:

$(".a-LinksList-item").addClass("t-Button").addClass("t-Button--pill");

.a-LinksLis…

[rimblas]

Debugging, Logger & Conditional Compilation

Debugging, Logger & Conditional Compilation

Aside from sharing knowledge, I sometimes blog to document and record something so I can use it again. This is one of those cases.

I use logger extensively, I would say on just about all my code. Code instrumentation is a critical aspect of writing good, maintainable, and scalable code. However, sometimes, there’s is such a thing as too much logging or as I like to think about it, too verbose.

So…

[rimblas]

Plugin: Cav Success Message

Plugin: Cav Success Message

Would you rather see “Action Processed.” or “New Department created.”, “Departed saved.” and “Department deleted.”?

This plugin allows you to configure your processing Success Message to a specific REQUEST.

This Process plugin was originally imagined and created by my good friend Gemma Woodof Cavanti. Gemma entrusted me with the maintenance and publishing of the plugin. I then ported…

[rimblas]

Plugin: Defer Report Load on Tab focus

New Plugin: Defer Report Load on Tab focus

I am happy to announce my new Dynamic Action plugin: “Defer Report Load on Tab focus”. Get it ap apex.world!

This Dynamic Action plugin is meant to be used for slow reports that run under a tab container. Put another way, it’s for reports that are not visible right away and perhaps may not be unless the user clicks on the tab. The plugin assists in deferring the load of an IR or Classic report…

[rimblas]

Move your APEX Plugin PL/SQL code to the Database

Move your APEX Plugin PL/SQL code to the Database

This blog post is about performance; Not about writing plugins. APEX 20.1 is out now, but this information applies to all version of APEX, but it will be especially of interest if you’re on a version earlier to 19.2. Let me explain.

Before the Oracle database can execute your code (either SQL or PL/SQL), it needs to understand it. This is called parsing. For practical purposes, the first time the…

[rimblas]

Video: 007 – Conditional Validation in APEX

Video: 007 – Conditional Validation in APEX

Do you ever run into a validation that perhaps you want the user to be able to bypass? Imagine, the validation is more like a warning and once you make the user aware they can proceed with the processing of the page.

If you rather watch this as a video visit:

Let’s imagine this scenario, you’re deleting a row but it has child records. You want the user to know that they can delete, but…

[rimblas]

How to Hide & Show a region’s TIMING during development

How to Hide & Show a region’s TIMING during development

You may be familiar with the handy Substitution String #TIMING# in Oracle Application Express (read more about TIMING and other Substitution Strings). When you add it to the footer (or header) of a region you get to see how long it took to run.

It’s pretty nice, but you may not want to display that value all the time. It’s sure nice during development. So why not make it optional? Or toggle it…

[rimblas]

Warn on Unsaved Changes for APEX_ITEM

APEX 5.1 introduced native functionality for warning the user when they attempt to navigate away from a page when the page contains unsaved changes. However, this feature doesn’t track items created via the APEX_ITEM API. Which brings me to the poor man’s Warn On Unsaved Changes.

Here’s the basic technique:

Use a regular text item (we’ll call it “Pn_COUNT_CHANGES”) on the page to track changes…

[rimblas]

Single Item CSS Grid Alignment

I often need to have a single item on a page (think a search item above a report for example). I would like this item’s label to still align to the right, but be flush with the left side of the report. Like so:

However, with the current CSS grid implementation of the Universal Theme, this type of layout is not possible in a declarative way. Depending on the screen size, you always end up with…

[rimblas]

Kscope Submission Ideas

Have you been thinking about submitting an abstract for Kscope? The submission deadline for Kscope18 is fast approaching! Submissions close on January 5, 2018!

Some of you may still be struggling to think of some topics. I’ve asked Dietmar Aust (Kscope18 APEX Track Lead), and Helen Sanders(Kscope18 Database Track Lead) for help with some topic ideas that would get your creative juices flowing.…

[rimblas]

Multi-Cursor Editing with Sublime Text

This little question on Twitter prompted me to record this brief video.

> “multi-cursor edit” …do tell!? https://t.co/5UsfqdsuUf

— Cary Millsap (@CaryMillsap) December 9, 2017

Some useful links: http://wphilltech.com/sublime-text-for-oracle-apex-developers/ http://apextips.blogspot.com/2015/09/compiling-oracle-code-from-atom-text.html