Joe Kerrjkerr.hashnode.dev·Jun 3, 2024Guide to IG Select Lists: Important ConsiderationsContext: APEX Interactive Grid (IG) columns of type “Select List” with a large list of return values and/or many IG rows reduce performance and consume more memory. The cause is APEX takes time to populate all the column’s possible Select List value...Discuss·36 reads#oracle-apex
Phil Grinhamphilgrinham.hashnode.dev·May 31, 2024Oracle APEX Template Directives - Directing More Than Just TemplatesThis is a quick blog post to show an easy way to use Template Directives in Oracle APEX as an alternative to common implementations of a specific problem. What problem is that? I have a report with a column that has a small set of distinct values, su...Discuss·1 like·89 readsOracle
Matt MulvaneyforHot off the Application Expressmattmulvaney.hashnode.dev·May 30, 2024Regex Searching APEX Apps for use of Deprecated FeaturesI wrote a story recently on deprecated APEX APIs and in there I wrote "You have to make proactive steps to resolve [deprecated APEX APIs]". So how do you spot that you're using deprecated features so that you can be proactive? The Advisor is not advi...Discuss·2 likes·62 readsorclapex
Anton Nielsenapexdebug.com·May 23, 2024ORA-29106: Cannot import PKCS #12 wallet.As the name of this blog suggests, sometimes this blog will just be about debugging a little something that occurs in APEX. This is one of those little things. If you attempt to access a TLS/SSL web service in any way (the declarative REST services, ...Discuss·44 readsorclapex
Anton Nielsenapexdebug.com·May 23, 2024Oracle APEX AuthN vs AuthZ...and How to Change MessagesAuthentication and authorization are closely related, so closely that they are often confused, combined or commingled (yes, I too thought the spelling was comingled). I argue, though, that in general we should maintain a strict separation: Authentic...Discuss·1 like·102 readsorclapex
Tom Lieberyaitcon.hashnode.dev·May 21, 2024Dynamic Action + Dialog Return ItemWhat workedDoesn't Work Button behaviourShortcut behaviour My Apex Shortcut calls apex.page.navigate via redirectToApexPage <a class="a-Button a-Button--popupLOV" aria-label="Erweitere Werteliste" title="Erweitere Werteliste" href="javascript:...ARUNKUMAR CN and 1 other are discussing this2 people are discussing thisDiscuss·97 readsAPEX Implemented Correctly? YES/NO?#oracle-apex
Rutvik Prajapatirutvikprajapati.hashnode.dev·May 20, 2024Deep Linking in Oracle APEXThere are times when we need to send users a direct link to a specific page, such as an interactive report, via email or users may also want to bookmark certain pages for easy access after logging in. When a user clicks on this type of URL and is not...Discuss·39 readsorclapex
Tom Lieberyaitcon.hashnode.dev·May 14, 2024Empty Table => looping Page?I have a view without Data in it: i use it in comment region a classic report has the same problemo.. This are my settings this is the result: Waiting circle: Get the Session and Query: SELECT SQL_ID FROM V$SESSION WHERE STATUS = 'ACTIVE' and u...Discuss·54 readsAPEX Implemented Correctly? YES/NO?#oracle-apex
Rutvik Prajapatirutvikprajapati.hashnode.dev·May 13, 2024APEX Dynamic Action only fired once. ( Static vs Dynamic Event Scope of Dynamic Action )Picture this: You've created an awesome interactive report with a new column to display icons or links. Now, you've added a dynamic action to this new column. When users click on the icon or link, you want it to update the status in the table and ref...Discuss·2 likes·168 readsorclapex
Rutvik Prajapatirutvikprajapati.hashnode.dev·May 13, 2024Linking to Oracle APEX Interactive ReportOne key feature within Oracle APEX is Interactive Reports (IR), which offer rich data analysis out-of-the-box and can be customized by end-users for sorting, filtering, and more. End-users can also save their customized reports as private reports, ex...Discuss·1 like·128 readsorclapex