Skip to main content

Remembering Joel #JoelKallmanDay

Around the end of 2008, a little over a year after I had started working with Oracle APEX, I had the opportunity to make some enhancements to an existing APEX application. I had numerous questions about APEX, but back then, it wasn't as popular as it is today. Most of my senior colleagues who worked with Oracle technology were either unaware of APEX or had only heard of it without much knowledge about it. During that time, one of my seniors introduced me to Oracle Forums, where I could ask my questions. He also shared a couple of blogs I could follow for the latest news and technical content. One of those blogs was Joel's. That was the first time I came to know about Joel. Little did I know at that time, one day I would join his team.

Joel R. Kallman

Fast forward to 2020, I had the privilege of presenting in a Zoom conference along with Joel. It was the first Office Hours session for the Oracle APEX India community. During this session, Joel had a special message for the attendees, and it wasn't about APEX.

  1. Use your talents to help others
  2. Donate of your excess
  3. Buy Local

These messages were shared during a time when the world had come to a standstill because of COVID-19. Especially the first two messages, they hold true at any given point in time.

I also recall another quote from Joel:

Service Above Self

You can listen to Joel's message in the below video

 

All of this speaks to one thing about Joel, he is not just an Oracle Database Expert and APEX co-founder; more importantly, he is a great human being.

A year later, in March 2021, I had the incredible opportunity to join the Oracle APEX product development team. It was a significant milestone in my career, and joining this team meant working alongside some of the best minds in the industry, including Joel.

When I have joined the team, these are the messages I have received from Joel.

In the recent Oracle Cloud World 2023 event, APEX was prominently featured in several important keynotes. It was evident that APEX has become a cornerstone of Oracle's application development strategy. APEX is now the first choice for application development within Oracle.

 

Joel's unwavering commitment and passion for Oracle APEX were always apparent. He had poured decades of hard work and dedication into its success. The recognition and acclaim that APEX receives today are a testament to his efforts. I can't help but wish that Joel could be with us today to witness Oracle APEX reaching new heights every day.

 Joel, we miss you dearly. Your legacy lives on in the continued success of Oracle APEX.

Comments

Popular posts from this blog

Interactive Grid - Conditional Enable/Disable

In this blogpost, I am going to discuss few approaches using which we can conditionally enable/disable Interactive Grid (IG) column(s) based on other column(s) values. Note:    There is a bug  30801170  in APEX 19.2/20.1 with respect to "enable/disable" dynamic actions for IG columns. Workaround for this bug is provided at the end of this blogpost . This bug has been fixed in APEX version 20.2. Client Side Only Conditions If conditions to enable/disable are simple, then we can check those conditions easily on the client side. For e.g. let's consider IG on EMP table with following SQL Query. SELECT EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO FROM EMP Let's consider the requirement as - Enable "Commission" column only when JOB is equals to 'SALESMAN' and disable "Commission" column in all other cases. This can be done declaratively using dynamic actions (DA) DA "Enable/Disable Commission - 1" Create DA and give it a prope

Interactive Grid - Bulk Operation on Selected Rows

What's the Problem? Let's say you have an IG on employee table and you want to update selected employees commission based on user's input. Ideally, it should be very simple, where you can write UPDATE statement in page process and select IG region as "Editable Region" under "Execution Options" of the page process. But, when you select rows and submit page, you can see that, this process won't get executed! The reason is  Selection of 'Row Selector' check-boxes is not considered as row-change. Thus selected rows are not submitted to server. So, is there any work around?  Yes! Luckily there are lot of JavaScript (JS) APIs available to work with IG. If you are not already aware, you can refer "APEX IG Cookbook"  or  JavaScript API Reference documentation. If we continue with above Employee IG example, when user selects IG rows, enters "Commission %" and clicks on "Update Commission" button, then we can writ

Interactive Grid - Process Filtered Data on Server Side

Recently one of the APEX developers has reached out to me and asked if it's possible to capture filtered rows data of the Interactive Grid on the server-side and do some processing. In APEX 20.1, there is a new API APEX_IG , using which we can achieve this. Photo by Jakub Kapusnak on Unsplash The approach is very simple and straightforward. Get the internal region id based on the Static ID given for the IG region Get the last viewed report id based on region id Open query context for the region and report using region id and report id Fetch and loop through the rows using the query context Do something with fetched rows And finally, close the query context If you have already done this for interactive reports, then you should be already aware of these steps. The only difference here is, we use APEX_IG APIs instead of APEX_IR APIs. For the demo purpose, let's Build an Interactive Grid on EMP table and let's give it a Static ID as emp Create a Textarea page item with