Skip to main content

Posts

Showing posts from October, 2026

Type @, Tag Anyone! Building Smart Mentions in Interactive Grid

@ @ @ @ @ ORACLE APEX Type @, Tag Anyone! Building Smart Mentions in Interactive Grid Click a cell in an Interactive Grid, type @, pick a customer from a live list, and the name or email goes right into the cell. Here is how I built it, and everything that went wrong on the way. Live Demo Interactive Grid AJAX Callback apex_json MutationObserver Custom dropdown I wanted to add @mentions to an Interactive Grid in Oracle APEX. I thought it would be an easy job. It was not. I lost a whole day on it. In this blog I will show you the plan, the things I tried that failed, and the code that finally worked. I am still learning APEX, so I will keep it simple. 1 What I built My page is Page 28. It has an Interactive Grid with three columns: Name, Comments and Email. In any of these cells you can type @ and a list of customers opens. Pick one and it is filled in. 👤 Name column Type @ , pick a custome...

Oracle APEX 26.2 : Interactive Report Enhancements

Interface Key phrases Computed columns Demo Readiness Oracle APEX 26.2 Interactive Reports that Reports are where most users spend their time in an APEX app. Release 26.2 refreshes the interface, adds quick typed commands and lets people create calculated columns by simply describing them. A cleaner interface Better spacing, consistent controls and friendlier small-screen behavior. Hover or tap a card to see what changed. Filter chips Active settings at a glance Search and filter settings appear as chips. Users can remove a single filter without rebuilding the rest. Multi-select Several values, one filter Pick many values from a column header. An existing filter is updated instead of a conflicting one being added. Number filters Minimum and maximum Numeric columns use range boxes instead of a long list of distinct values. Date filters Calendar picker Mix presets, exact dates and ranges. The dialog remembers what you applied before. Chart, Pivot, Group By Reorganized ...

Oracle APEX 26.2: The Highlights

Release 26.2 is available for on-premises Oracle APEX 26.2: The Highlights Release 26.1 introduced APEXlang and the first wave of AI features. Version 26.2 makes them practical for daily work, from importing changes to protecting data and connecting to Oracle Cloud. 5 Key areas covered 1 File is enough to import 2 Layers of access control At a glance File-level import Bring in only the APEXlang file you changed. Interactive Reports A major refresh, including the AI-powered features. Deep Data Security Data rules enforced inside the database. OCI authentication A simpler way for apps to reach OCI services. AI controls Set reasoning effort for each AI Agent. Developer workflow Importing one file at a time APEXlang describes an application as readable text files that fit naturally into Git and code review. Until now, even a one-line fix meant importing the whole application. File-level import changes that: you load only what you edited, and everything else st...

Mastering Keyboard Shortcuts in Interactive Grid – Part 2

Alt F S I PART 2 Mastering Keyboard Shortcuts in Oracle APEX Interactive Grid – Part 2 10 more shortcuts so your hands never leave the keyboard Oracle APEX Interactive Grid Keyboard Shortcuts JavaScript 0 Total shortcuts 0 New in Part 2 0 Code block to paste 0 Plugins needed ← Previous post Part 1: Excel Style Keyboard Shortcuts in Interactive Grid This is Part 2 of my keyboard shortcuts series. In Part 1 I added four shortcuts: Alt+A, Alt+D, Alt+S and Alt+R. After using them for some days, I wanted more. Searching, sorting, filtering and duplicating a row still needed the mouse, and that felt slow. So here I add ten more shortcuts to the same grid. I will also tell you which ones did not work for me, so you can save your time. If you did not read Part 1 yet, please read Part 1 first. It shows how to make the grid editable, how to set the Static ID and how to set the cursor focus. Part 2 uses the same setup. ⚡ All Shortcuts at a Glance The first four ca...